Question: Sisense installation on Windows server stuck at 20% install and then the installer fails: In the %temp% install logs we saw the following errors: Error 0x80070570: Failed to extract all files from container, erf: 1:4:0 Error 0x80070570: ...
If you need to color columns in a column chart based on a different formula you will need to use the following solution. For this example, we will color the columns that calculate [Total Cost] for the [City] by another value, that is calculated by t...
Question: When I'm trying to sign out from my existing login. It shows a warning alert "Sign out failed". Answer: This error might happen when Sisense Activation is not run with administrator privileges. To fix this error please try the following:...
Question: I am trying to download and install Sisense but when I do, it says the license server is unavailable. Answer: If your license is up do date, please take the following steps: Within the Windows menu, search for Sisense Activation, then ri...
Question How can I trigger a popup every time I open a dashboard using BloX or JS, as shown in the picture? Answer You already have the code for the popup itself then you can easily wrap it as a plugin and use the "dashboardLoaded" event to tr...
Question When using the Indicator Sparkling template, once I add an Item (dimension) for the sparkline, the carousel navigator arrows appear. Since they are not needed, I would like to hide them. Is there a way to do that? Answer You can use the ...
Question Is there a way to set the default panel of the BLOX widget to the month that is currently set in the FilterDash month? That was when a user loads the page, they don't get confused by the mixed messages of BloX vs rest of widgets? Answer Y...
Question I am trying to make it a widget button and switch the dashboard once it was clicked. Is there a way to achieve it? Answer You can use this script. It uses the standard BloX OpenURL action and will build and style a web page opening button...
Question Would it be possible to add a scroll to a widget location action? So I have a top panel that has an action of: "navigate to Actions widget"? Answer You'll need to create a custom action and include something like: var elmnt = document.ge...
Question When applying the script in BloX - the change is not applied in PDF. The example of the script: This looks fine in the BloX editor, Dashboard, and PDF preview: But the script is not applied to the exported PDF: Answer Replacing the...
Question Is there a way to tie a default filter (set to "all") so that instead of Blox just displaying the top name in from the data, it triggers a custom phrase instead (like "Aggregate")? Answer Here's a simple way to do something of the kind! ...
Question How can I create a Charting Gauge in Blox? Answer You will need 5 items; A field for indicating the pointer-value. In the example the number in the middle and the yellow markerGauge minimumGauge maximumOne and Two indicate the chart inte...
This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionalityDashboard training for end users Dashboard Planning Dashboard planning goes hand in hand with project planning, and will ...
Issue In Survey Data you might have 10th or even 100ds of parameters per questionnaire, Sisense suggest transposing all the parameter into one column (See article). Once you do that you might run into an issue filtering questionnaires that answered ...
This post will show how to create an easy to use Radiobutton filter (single selection type) with a list of predefined custom time frames. The created time frames can also be used for breaking by charts or pivots, providing a visual comparison betwee...
This article explains how to automatically switch between dashboards every predetermined amount of time. This might come useful, when you have multiple dashboards that you want to be presented in a cycle on a monitor to reflect updated data\records....
Question: Viewers don't have the ability to show and hide grand totals which I want them to be able to do. Is it possible to achieve with Blox functionality? Answer: The pivot widget's "style" attribute includes settings for grand totals, and you ...
Analytical Need Customer's fiscal year does not comply with the Georgian 12-month calendar and starts on a different date than January 1st. Example: Customer’s fiscal year is from April 1st to March 31. This means that April should be flagged as...
Analytical Need Market Basket Analysis is a data mining technique that is widely used to identify consumer patterns, such as which items are purchased together, or how the purchase of one item affects the likelihood of another item being purchased. ...
A relationship between tables specifies the field/s which the 2 tables have in common. In Sisense, we create relationships between tables in the ElastiCube. Poorly modeled data relationships can lead to one or more of the following: Complex data se...
