Sort YYYY-MM in graph

[stekol61]

Hi!

I have create Month as 'Year(event_start_time)&'-'& Month (event_start_time)as Month'.

The result will be like '2018-sep'

When i used it as x-axes dimension in a graph the order is not correct.

How can I solve this?

[nsetty]

Try below

Sorting -> Sort by Expression

Include -> [event_start_time.autoCalendar.MonthRelNo]

[sunny_talwar]

May be create the dimension like this

Date(MonthStart(event_start_time), 'YYYY-MMM') as Month

[stekol61]

Hi!

When using this expression the dateformat is like this: '2018-09-01', not '2018--sep''

Date(MonthStart(event_start_time), 'YYYY-MMM') as Month

[stekol61]

I found the solution.

Use 'Max(event_start_time)' as sort expression