Having difficulty with Dashboard performance For slow-loading dashboards, you will need to consider the following: Too Many Widgets - The best practice is to have 6 to 8 widgets per dashboard. This is due to the number of concurrent queries requir...
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. Soluti...
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 ...
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...
Analytical Need Weighted 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, ...
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...
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 ...
Introduction Many times we'd like to analyze our data according to top/bottom ranking positions, for this we have 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. p...
Analytical Need You want to display a chart/table with the Top X and Bottom X, all in the same widget Modeling Challenge Sisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom. Solution Widget Filter: ...
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 (...
Analytical Need Pareto analysis is a technique based on the Pareto Principle which states that 80 percent of problems or effects are produced by 20 percent of causes. This type of analysis can be useful in the stage of decision making, to identify t...
Analytical Need Aggregation functions are used to group a set of values to perform calculations that return a single value. SUM(), MEDIAN(), and COUNT() functions are some of the most common aggregation functions examples. Simple aggregation func...
The last month with data isn't the current calendar month (payroll for instance).The out of the box feature of Sisense supports only the last calendar month Below shows a solution to have a default filter that shows the most updated month with data....
At times, you might want to limit the items suggested in a dashboard filter by another field's value (for example: enable the user to choose between all subcategories under a specific Product Category). This functionality can be achieved using a depe...
The following article describes how to answer the following question: Which countries have sales for product A but not for product B The solution is based on using the Filtered Measure plugin. 1. Go over the instructions in the Technical Details of t...
