cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Analytical Need

Sometimes we want to display 2 dimensions and one measure in a widget. Ordinarily we will use a pivot table for this purpose.

A pivot table may be very nice & good but it doesn't allow us to filter the dashboard based on values from the dimension, plus it is a lot less visual.

Solution

We will use a scatter chart. You may say a scatter chart is destined to display 2 measures broken by a single dimension but luckily, Sisense is much more flexible than that and we can add our dimensions in the X-Axis & Y-Axis without any aggregation functions.

Remember to add All items and not an aggregation function :

Community_Admin_1-1634296258279.jpeg

The measure will appear under Size.

Further complexity: if we have numbers that are shown as dimensions (implementing what we talked about until now) and not aggregated using Sum/Avg etc, like so :

 

Community_Admin_2-1634296258524.jpeg

We can group them in the cube and display them like so :

Community_Admin_3-1634296258431.jpeg

Now, we can select any of the dimension values and filter the dashboard according to them and we have a much prettier widget.

Rate this article:
Comments
hadardo
7 - Data Storage
7 - Data Storage

The order of each of the axes changes based on data (usually when there are missing values in categories). Is there a way to keep the order of the categories (there is only one script available online, and it doesn't work for the X axis)?

OlehChudiiovych
Sisense Team Member
Sisense Team Member

Looks like this could be tackled by another script, but I was not able to find any sample or snippet that could be used to achieve the same. If this is a highly requested feature I suggest reaching out to support via portal to register the idea so this would be implemented as a part of the product instead of a custom solution. 

Version history
Last update:
‎11-10-2023 12:23 PM
Updated by: