Knowledge

How to Diagnose Slow Dashboard Load Time

For detailed steps on diagnosing slow Dashboard load times, please refer to this new Community Article: https://community.sisense.com/t5/knowledge/how-to-diagnose-slow-dashboard-load-time/ta-p/3148

Performing an OR between dashboard filters

Analytical Need A common requirement in data analysis is to be able select values from several filters and to see the results that contains all of those values and not only the results where only selected values appear.In fact, the requirement is to ...

Exclude 'today' using jaql

Sometimes we'd like to see all our data up to today, not including. It is very easy to achieve this within the Elasticube by creating a custom column which calculates the daydiff between the date to today i.e. daydiff(now(),[date_field])and then filt...

Year over Year for the past x months

Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period.For example, we wish to see how we perform from Sep last year to Aug this year and compare it with Sep 2 years ago ...

Year over Year analysis

This article demonstrates how to visualize year over year comparisons. This will be useful if you want to compare the performance of multiple years by the same day, month, or quarter. This will require the creation of one column in your ElastiCube.In...

Calculating Weighted Average

Analytical NeedWeighted average refers to the mathematical practice of adjusting the components of an average to reflect the importance of certain characteristics.This practice can be useful in different scenarios, a few examples: In economics, this ...

AND filter - How to identify Items that have all selected values

Analytical Need I would like to count all the products that are sold in Germany & Canada. When you select Germany and Canada in a typical Sisense filter, it will give you results for products that are sold either in Germany or in Canada but not sold ...

Forecasting by Historical Performance

Analytical Need While tracking your sales performances during the quarter and compare it with the quarterly target, wouldn’t be helpful if you’ll have an indication for your current pace and whether you’re going to meet your quota by the end of the q...

Create Widgets With Month Or Day Names By The Correct Order

DescriptionCreating a sorted label for the week days or months (names) in a widget is not a simple task. The base sorting is based on alphabetical order and not on the logical order of days or months. For example (Issue) :FridayMondaySaturdaySundayTh...

Ranking range

IntroductionMany times we'd like to analyze our data according to top/bottom ranking positions, for this we have the out-of-the-box ranking filters. At other times, we'd like to see certain ranges, such as the ranking range between certain ranks, i.e...

Top 5 + Bottom 5 In The Same Chart

Analytical Need You want to display a chart/table with the Top X and Bottom X, all in the same widget Modeling ChallengeSisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom.SolutionWidget Filter: Create your w...

Send Pulse Notification Only By The End Of The Month

Analytical Need Send Pulse notification only by the end of the month to track monthly performance. Cube is being built daily. Modeling ChallengeSisense will trigger Pulse alert after every cube build if the condition is met. If the cube is being buil...

Performing An Aggregate Product In Sisense

Purpose:To create a product aggregation in Sisense (multiplies all values together, similar to the way a sum function adds all values together). Situation:A financial use case has a table with relative daily gains/losses for certain securities (think...

Custom Month and Year to Date to Last Year MTD and QTD Calculations

Month to Date (MTD) and Year to Date (YTD) calculations provide us results of activity in the time between the beginning of a date (can be a month or year in our example) and the beginning of the current month or year. This in turn allows data analys...

Calculate and compare selected member to non-selected members

Analytical Need You want to display a value for a selected member (i.e. Salesperson) vs the min/max of all non-selected members. This can be achieved using modeling techniques but this solutions describes how to do it purely in the front end. Solutio...

Sisense Community

Knowledge Base Articles