Forum Discussion
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 format i needed.
Resulted dataRequired Format Data
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 :)
3 Replies
try this:
In the top right corner, you should have a option for order, select month instead of sthe amount.
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 :)