How to display month as a sorted manner in graph

Q&A
,
1

Hello There,

I have created a line chart and in x-axis I want to show month but in sorted manner. Currently this month I am taking dynamically from data set.
How can i sort month without creating static month column.
Also, for sep 0 is displaying, how can I hide 0 from display.

Thanks & Regards,
Sonal Jain

image

2

Hi @sonalJain,
month isnt a date formated field?
Then you could create a numeric field Jan = 1, Feb = 2 etc. and sort the x-axis with the new field.
BR

3

Hello @ErikG,

I tried to do the same but in x-axis digits are displaying instead of Jan, Feb. Month is not a date format field.

Thanks & Regards,
Sonal Jain

4

did you tried that?

grafik
grafik917×343 50.8 KB

5

I tried but I am not getting sort option. This form_generated_month is calculated field.
image

Thanks & Regards,
Sonal Jain

6

Did you check the arrow “>” on the right side of “form_generated_month”

7

Hello @ErikG , It worked. Thank you so much for the response.

1 Like