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

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

mceclip3.png 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 :
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 :
We can group them in the cube and display them like so :
Now, we can select any of the dimension values and filter the dashboard according to them and we have a much prettier widget.
Version history
Last update:
‎03-02-2023 08:27 AM
Updated by:
Community Toolbox

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

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy