Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my application the months comes jumbled up, i want to know if have an way to force the months months months to be ordenate, in the script or set analyses, I tried in the option "sort" in chart properties but none option was effective.
your month is based on a date or is it a text field?
if it is from a date field: month(Date)
if it is from a text field use dual function:
dual(‘January’,1)
dual(‘February’,2)
etc
when using it in chart it will sort correct!
your month is based on a date or is it a text field?
if it is from a date field: month(Date)
if it is from a text field use dual function:
dual(‘January’,1)
dual(‘February’,2)
etc
when using it in chart it will sort correct!