Bar Chart Sorting - Alternative Dimensions

Coldie — Sun, 14 Jan 2024 18:06:16 GMT

Hello guys,

I haven't been able to figure out how to custom sort a bar chart when using alternative dimensions.

In the example file I have three dimensions in a bar chart.

1. Due Range Description
2. Customer Name
3. Country

I would like the "Due Range Description" dimension use a custom sort based on the DueRange field (ascending order). The Customer Name and Country dimensions should be sorted by Invoice Amount (descending order). When I fix the "Due Range Description" sort and select Customer or Country and change their sorting, the Due Range reverts to sorting by in invoice amount.

Several posts suggest this should be possible, but I haven't been able to get it to work. So, is i possible and, if so, what am I doing wrong?

I use QS (February 2022 Patch 3).

TIA

Re: Bar Chart Sorting - Alternative Dimensions

rubenmarin — Sun, 14 Jan 2024 18:22:50 GMT

Hi, you have to select each dimension to configure it's own sort order, in the attached file Due Range is sorted by range, the other two are sorted by descending Sum(Amount)

Re: Bar Chart Sorting - Alternative Dimensions

Coldie — Sun, 14 Jan 2024 18:44:01 GMT

Thanks, it's working now.

topic Bar Chart Sorting - Alternative Dimensions in App Development

Bar Chart Sorting - Alternative Dimensions

Re: Bar Chart Sorting - Alternative Dimensions

Re: Bar Chart Sorting - Alternative Dimensions