Sort x axis in chart by month

zachary
Level 1
Sort x axis in chart by month

Hello,

I have a graph in chart with x-axis group by month of year and I would like to have the graph from Feb to Jan of the next year, or from March to Feb, not from Jan to December.

 

Do you know if it is possible to do that in the chart mode ?

 

Thank you very much

 

0 Kudos
2 Replies
AlexT
Dataiker

Hi @zachary ,
You should be able to use a date column,  aggregate by month and filter for the month range you want to display. 

Screenshot 2023-05-29 at 8.06.17 AM.png

Thanks,

0 Kudos
zachary
Level 1
Author

Hello @AlexT, thank you for your answer. I would like to have a seasonal chart with one curve from March 2020 to Feb 2021, one from March 2021 to Feb 2022, all on the same graph to make comparison. So the filter with the month range doesn't work. If anyone has another solution, I would like to hear it.

Thank you very much! 

0 Kudos