Forum Discussion

lring's avatar
lring
Cloud Apps
02-04-2025

Break by month not in chronological order (displaying 01/2025 before 12/2024)

Hi, I have some charts where the Break By is a date field which is displayed as MM/YYYY, and I have the charts filtered to show the Last 2 Months. Now that we're into a new year I've realized that the charts are displaying by numeric month order and ignoring the year, so 01/2025 is before 12/2024. How do I re-order the break by date to show 12/2024 before 01/2025? Thanks!

dashboards & reporting

4 Replies

  • lring's avatar
    lring
    Cloud Apps
    02-06-2025

    Hi DRay , I'm not sure if that's what I'm looking for because that example has the date as the X-axis category, and I'm only using the date as the Break By field:

     

  • DRay's avatar
    DRay
    Sisense Employee
    02-06-2025

    Hi lring,

    Sorry, I should have been more specific. The query in that doc, 

    CREATEDATE(
GETYEAR(NOW()),
GETMONTH([Date]),
GETDAY([Date]) )

    is what will need to create the date column that you can sort by. 

  • DRay's avatar
    DRay
    Sisense Employee
    03-04-2025

    Hello lring,

    I’m following up to see if the solution I offered worked for you.

    If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.