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

Works With Any Chart Widget That Allows Right/Y2 Axis.

CHALLENGE:

As a dashboard designer you might want to sort the X axis of a chart based on some aggregated values but want to show another aggregation.
 
For example:
In the below widget we would like the countries to be sorted by Total Cost while displaying Total Revenue:
Steps:
1. Sort by the desired value field, in this case Total cost.
2. Put this field on the Right axis.
3. Go to the design pane on the right hand side and scroll down to the Y2-Axis:
4. Set the Min and Max values to be out of the scope of the actual values: In this case as we dont have negative values, I have set the Min value as -50 and max value as -1.
5. Turn off the Y2 axis so that it doesn't show on the chart.
6. Save the Widget and Done!
Version history
Last update:
‎03-02-2023 08:34 AM
Updated by:
Contributors
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: