Community Conundrum 25: Feature Visualization is now live! Read More

How to sort Months in proper order in a chart

Level 1
How to sort Months in proper order in a chart

Hi All,

I have a chart which is showing monthly population of a city. Now when I am creating this chart, it is sorting the data either in ascending or descending order of Monthly population but I want to show the month on month trend hence I want my data to show as Jan,Feb,Mar,...,Nov,Dec. 

Could you please let me know how I can achieve this in dataiku.

1 Reply
Dataiker
Dataiker

Hi, 

Do you have a proper timestamp in your data? In order to build time series visualizations you need to have a parsed date in you X axis. 

If you only have month identifiers then I suggest you concatenate it to a dd-MM- yyyy format so you can plot the values as a time series.

Hope this helps