Sorting by a different column on bar chart

[kashjaniqlik]

Hello

I have a bar chart which shows a count of a number (some issues that we have in business) on Y Axis by Month and Year on X Axis.

The month & year is derived by a date (Issue start date) during the script load and this month & year is shown on x axis. I would like to sort the bar chart by the original column (Issue Start date) rather than the derived column (Month & Year).

I have been trying to sort the chart using the Issue start date in the expression field of Sort tab but it doesn't seem to work. If I'm able to do this then the chart will be properly sorted by issue start date and so will be the derived column on the x axis.

Any help will be great.

Many Thanks

[Gysbert_Wassenaar · Accepted solution]

Create your MonthYear field as a date with the display format you want. For example as date(monthstart([Issue Start date]),'MMMM YYYY') as MonthYear

[kashjaniqlik]

That's Great. Thanks Gysbert.