Hello,
I'm trying to use a Line visualisation instead of a Line Chart, but I found it hard to sort the months on the x-axis. If I use month name, the sort is April, August, etc. ; when I sort it with the field calendar month number, the sort is 1|January, 10|October, 11|Novemeber.
I cannot find an efficient way to use visualisation. The Line Chart sorts the calendar month numbers without problem or I can sort the month names using the calendar month number. It seems pretty limited the use of this visualisation in reporting (In Dashboards I can manually sort the months)
It would be faster to use a chart than to create a data item with a CASE statement to sort the months when I already have calendar month number.