Ready for Dataiku 9? Try out the Crash Course on new features! GET STARTED

How to sort Months in proper order in a chart

kuntal_bhowmick
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
VinceDS
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

A banner prompting to get Dataiku DSS