Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

MonthYear is not in sequence

Dear experts

 

My report is not showing the monthyear in an order.

I tried for weekyear aswell same thing.

 

Any suggestion please.

 

Thanks

Mahad

Need Help

3 Replies

  • ToddChitt's avatar
    ToddChitt
    Icon for Super User rankSuper User
    4 years ago

    Have you set the Sort By Column attribute of the column you are displaying? Normally, Date dimension tables have month name and year, and also Month Number, and somethinge YYYYMM (202201, 202202, etc.) 

    Highlight the column and look under Column Tools toolbar.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi ToddChitt

       

      Thanks for your response. I trield sorting it out based on YearWeek and YearMonth. Yet no changes.

       

      Any other workaround?

       

      Regards

      Mahad

      • ToddChitt's avatar
        ToddChitt
        Icon for Super User rankSuper User
        4 years ago

        Your Date dimension should have columns like this:

        • Date (sample: 1/1/2022)
        • Month Number (sample: 1 - 12)
        • Month Name (sample: "Jan" or "January", etc.)
        • Calendar Year (sample: 2022)
        • YYYYMM or YearMonth (sample: 202201)
        • Month-Year to Display on my chart (sample: Apr-2022)

        Now select a column from the Fields well, and under the Column Tools menu, use the Sort By Column button as follows:

        For [Month Name], sort by [Month Number]. (this makes "January" show up ahead of "April")

        For [Month-Year], sort by [YYYYMM]

         

        But now, in looking at the posted picture, the X axis is NOT in alphabetical order as evidenced by the fact the "Nov" shows up before "May". So I'm guessing that the visual is actually sorted by one of the Value column, (which, by the way, is the default). Click the elipsis in the upper right corner of the chart and make sure you sort by the X-Axis, and make sure that the X-Axis column is properly sorted per above.