Forum Discussion
Solved
Line chart x axis formatting for months
Hi Team, I am facing issue for ordering the months on x-axis of line chart. The month names are in Text data type. Below is the image of the data which i am getting result and the image in which form...
OK,
Next step, order it by number of month, lets explain how:
In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.
tell me if works :)
Yes i tried it. Since the months are in text datatype. So it is arranging in asseniding or decending orger of alphabets of Months.
OK,
Next step, order it by number of month, lets explain how:
In the query, I obtain the month number. Then, Ill go to modeling section, and select the field "Month", go to sort by column, and select the Month Number.
tell me if works :)