cancel
Showing results for 
Search instead for 
Did you mean: 

Charts order

SOLVED

Charts order

Hi! Someone knows if it is possible to order the bars inside the chart from large to small? Or select just the best ones to apear on the dashboard?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Charts order

If you're creating your bar/column chart using a Group By and have Time Interval = None, you can sort the results by clicking "Show Top/Bottom" next to your Group By column - see this docs page (https://docs.magento.com/mbi/data-analyst/dev-reports/order-data-top-bottom-feat.html). This feature also lets you choose to show a specified number of the highest/lowest values (e.g. top 5). If you're not using Time Interval = None, MBI will always put reports in date order.

View solution in original post

2 REPLIES 2

Re: Charts order

If you're creating your bar/column chart using a Group By and have Time Interval = None, you can sort the results by clicking "Show Top/Bottom" next to your Group By column - see this docs page (https://docs.magento.com/mbi/data-analyst/dev-reports/order-data-top-bottom-feat.html). This feature also lets you choose to show a specified number of the highest/lowest values (e.g. top 5). If you're not using Time Interval = None, MBI will always put reports in date order.

Re: Charts order

Thanks, that´s exactly what I was looking for.