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.

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)?

Version history
Last update:
‎10-15-2021 04:11 AM
Updated by:
Contributors
Community Toolbox

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

Need additional support?:

Community Support Request