How to sort Months in proper order in a chart

kuntal_bhowmick
kuntal_bhowmick Registered Posts: 3 ✭✭✭✭

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.

Answers

  • VinceDS
    VinceDS Dataiker, Alpha Tester, Dataiku DSS Core Designer Posts: 45 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

Setup Info
    Tags
      Help me…