Sort graph by date

[sergio0592]

Hi all,

I have a line graphe with date value in abscissa. I have three lines, one per year and my date field is formatting with Oracle to_char function (to_char(Date_field,'DD/MM') . So, i expect 01/01, 02/01, 03/01.... 31/12.

I have even tried to sort with expression match(Date_field, '01/01',02/01','03/01'...'31/12'). Usually match() function works but not in this case!! Is there a way to achive that??

[sunny_talwar · Accepted solution]

Try this as your calculated dimension:

Date#(Date_field, 'DD/MM')

or use it as your sort expression with existing dimension:

Date#(Date_field, 'DD/MM')

[sergio0592]

Thanks Sunny, first issue works perfectly!

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .