Not able to sort dates in line chart

[udaya_kumar]

Hi,

I have a line chart in my dashboard, it contains date like Jan-11,Feb-10.....

I am not able to sort the dates. I want the dates to be look like Jan-10 Feb-10 Mar-10 Feb-11 Jan-12 Feb-12.

Like it should be sorted in ascending order.

PFA of the chart.

[nagaiank]

If your dimension field is linked or derived from a date field, use that date field as sort expression in the sort tab of the chart properties window.

[udaya_kumar]

Hi,

I am using only one dimension, that is month_name for the chart.

That month_name is not sorting in the chart.

[nagaiank · Accepted solution]

Use the following expression in the Sort By box in the sort tab of the chart properties and see if the dimension sorts correctly:

Num(Date#('1-'&month_name,'D-MMM-YY'))

[udaya_kumar]

It's working fine,

thank u very much sir

[#6]

I'm having the same problem, except my month names aren't derived from a date field, but are instead just text names.  Any ideas how to get the sorting to work properly?