Users could sometimes want to compare performance on a particular time period vs the immediately preceding period. Sometimes those periods are not of a common size like months or quarters. It could be a campaign that lasts a few days, or an arbitrar...
How to Calculate Absolute Sum We have a table with data and we are going to calculate the absolute SUM for [sum] column. We divide this into two parts. First of all, we SUM all positive values with the formula ([Total sum],[sum1]) Th...
In case when you need to change the owner of multiple dashboards there are few ways: 1) In case all the dashboards are in 1 folder then you can select the folder and export the dashboards. After what, import the dashboards back under the user to who...
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 f...
Analytical Need Attached below is a BloX template.A common request is to have a 'From To' input at the top of the dashboard to affect a calendar range selection of dates.To achieve this need we can utilize BloX's form capabilities.Picking a date ran...
Requirement In this article, we will look to create a personalized dashboard navigation landing page that shows: The logged user's most popular dashboards.Most popular dashboards on the company level. Consider further enhancing the logic present...
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. T...
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...
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 ...
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 ...
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 indi...
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...
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...
Topics Covered:Limitations of mobile widgetsTesting methodsBest PracticesSizing for mobileLimitations Of Mobile WidgetsAll widgets are put into a single rowWidgets are given a height of approximately 650pxPivot tables render poorly (text is shrunk si...
Sisense has the capability to share a local file (excel, word, pdf etc.) with dashboard users. Note: The file must be saved on the server in the following path: %programfiles%\Sisense\PrismWeb. You can create a new folder or save it under 'Resour...
ChallengeThe utility of a sub-second refresh rate is limited to monitoring use-cases. This, of course, is not BI, but there may be cases where a BI use-case also incorporates live streaming data to trigger an action or decision.An example is if there...
CaveatsIf you have windows, the only way to do this in a way that will show up in exports is to create a string representation of the date in the elasticube and use that. There are limitations. If these are significant, look at a move to Linux. This ...
Many times we’d like to be able to compare a few items out of a large set to see how they relatively behave. For example, how a certain period did compared to any other period, or how a certain country’s sales or sales representative achieved compar...
In this post we will cover two scenarios:Legend-Based Color: conditionally format the elements in order that they appear in the legend (alphanumerically)Value-Based Color: conditionally format the elements by their total sum (or an aggregation of you...
IntroductionThis article describes how to dynamically color the Data Bars within a pivot table based on the cell values. Presented here are two methods:Use stock gradients to provide different colors based on cell valuesDefine RGB shade magnitudes ba...
