Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

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...

intapiuser by Community Team Member
  • 669 Views
  • 0 comments
  • 0 kudos

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...

intapiuser by Community Team Member
  • 1131 Views
  • 1 comments
  • 1 kudos

Calculating Weighted Average

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, thi...

intapiuser by Community Team Member
  • 632 Views
  • 0 comments
  • 0 kudos

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 ...

intapiuser by Community Team Member
  • 378 Views
  • 0 comments
  • 0 kudos

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...

intapiuser by Community Team Member
  • 525 Views
  • 0 comments
  • 0 kudos

Ranking range

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...

intapiuser by Community Team Member
  • 1315 Views
  • 0 comments
  • 0 kudos

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 Challenge Sisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom. Solution Widget Filter: Create you...

intapiuser by Community Team Member
  • 1016 Views
  • 0 comments
  • 0 kudos

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 (thi...

intapiuser by Community Team Member
  • 714 Views
  • 0 comments
  • 0 kudos

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...

intapiuser by Community Team Member
  • 257 Views
  • 1 comments
  • 1 kudos

Pareto Analysis

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 th...

intapiuser by Community Team Member
  • 381 Views
  • 0 comments
  • 0 kudos

Conditional Filtering on Measured Values

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 function...

intapiuser by Community Team Member
  • 1708 Views
  • 0 comments
  • 0 kudos

Show last month with data

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.S...

intapiuser by Community Team Member
  • 549 Views
  • 0 comments
  • 0 kudos

Limit Dashboard Filter Items By Another Filter

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...

intapiuser by Community Team Member
  • 583 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: