New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

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