How to sort Months in proper order in a chart

kuntal_bhowmick
kuntal_bhowmick Registered Posts: 3 ✭✭✭✭
in Using Dataiku

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.

· Share on FacebookShare on Twitter

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

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…