Sort order issue in combo chart

Nivetha_AZ — Sat, 16 Nov 2024 04:07:07 GMT

Hi,

I have created a combo chart which displays rolling 12 months data

Dimension : Sales_MonthYear
Expression: sum({<Sales_MonthYear_number={"<=$(vStartmonth)>=$(vEndMonth)"}>}sales)
Sort order: Sorting for Dimension 'Sales_MonthYear' is set to 'Custom' and have used the 'Sales_MonthYear_number' field.

By default, the sort order is working as expected but when rolling 12 months condition is applied, the sort order on month is not working.

Sorting for Sales_MonthYear is Custom and have user the Sales_MonthYear_number field.

I have attached the screenshots of the sorting condition and the chart

Re: Sort order issue in combo chart

sunny_talwar — Thu, 14 Nov 2019 13:04:59 GMT

Change sorting expression to this

Only({1} Sales_MonthYear_number)

Re: Sort order issue in combo chart

Nivetha_AZ — Thu, 14 Nov 2019 13:15:48 GMT

Thank you so much it worked

topic Re: Sort order issue in combo chart in App Development

Sort order issue in combo chart

Re: Sort order issue in combo chart

Re: Sort order issue in combo chart