Introduction: By using the re-branding API you can replace the default homepage with a specific dashboard. (For further explanation of the branding functionality please read this article.) Keep in mind you need to leave only what you change ("string"...
Analytical Need In this article, we can find a suggested approach on how to better maintain our Sisense environment. The current tools and methodologies take us to an encumbering and challenging work. By creating a dedicated dashboard to show our env...
Introduction The following enables to change the value in pivot tables to specific strings, while allowing the use of conditional coloring as normal. Step 1 - Add The Following Script To Your Pivot's Edit Script widget.on('ready', function(){ $('td[c...
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 th...
This page is intended to keep a focus on Dashboard design in terms of: Planning Implementation User experience and functionality Dashboard 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 A...
*****Windows Only**** When having a pivot table which contains more than one value and present the grand total for each of the values, the total row is called “Grand Total” In some cases you can be faced with users’ requirement for changing the ‘Gran...
This article will explain how to create reset to default filters button in BloX This helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. Create a new custom action with the below code: *Make s...
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 between...
This article describes how the append dashboard filters as URL params to apply scope automatically to embedded dashboards. The example below shows how to apply members as filters. If you already have dashboard filters defined, you can write the follo...
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. ...
In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers. This can be used for cases where you would li...
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash files...
Sometimes we would like to hide a column in our pivot table so we will be able to apply a specific logic or order the table by a column without displaying it. The following script will allow you to hide the needed columns in your Pivot table. To impl...
Question Is there any way to get the views to execute sequentially instead of simultaneously? How does the dashboard in Sisense execute the queries? Answer The Sisense client application does attempt to send out all queries (one per widget) at once, ...
