How to Change the Pivot Header Row Style with TransformPivot This solution is based on Pivot 2.0 API supported in Sisense version L8.2.1 or later (not supported in Sisense for Windows). For this solution, we shall use cellStyle from Pivot 2.0 API. Th...
If you are using a gauge indicator in your dashboard and want to make the gauge reflect a percentage like shown below (elasticube is Sample Retail) - Follow the steps below - Steps:1. Create an indicator widget and add a value you want to review. In ...
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" is...
Analytical Need Often times, we are required to present all the existing records in our dimension whether we have or don't have records to aggregate for it from our fact table or simply, perform a left join on-demand instead of the by-product inner-j...
Sisense has several different ways to present table data. Often we pick whichever one we find first that seems to work, instead of picking the table that best meets our requirements. This can result in unnecessarily slow dashboards. Table:A table is ...
*****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 face with users’ requirement for changing the ‘Grand Tot...
What is good dashboard performance?Dashboard performance is the time it takes to load a Sisense dashboard. We want our users to have a good experience when working with our data. The time taken to load the dashboard is the first step. Each individual...
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...
Please note this article is useful for Windows users and users who use older Linux versions that pre-date the Analytical Engine. Control charts are a common way to show a trend line of some metric, as compared to an upper and lower boundary. This art...
Currently, in Linux installation, you can face widget [Pivot2]. This is a new realization of the widget [Pivot]. This means that it has new styles, new classes, etc. Almost all the scripts to change styles of the resulting table used DOM selectors to...
Need A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard.However, when you are a viewer, you cannot even re-order the pivot columns as you ...
In Sisense, you can view two separate dashboards side by side and slice/dice the data differently for each of them. Of course you could open each dashboard in a new tab, but then you can't see them both at the same time. This post describes how to cr...
Analytical NeedIn 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 envi...
Sometimes we'd like to define variables to hold specific metrics and use them throughout the dashboard in several places, with the ability to change / control them in one repository without the need to manually change each formula or widget.A good us...
This article will explain how to create reset to default filters button in BloXThis helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. 1. Create a new custom action with the below code: *Make...
