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

[lring]

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!

[DRay]

Hi @lring,

Thank you for reaching out. I think this post will help. https://community.sisense.com/t5/knowledge-base/creating-a-year-over-year-chart-in-sisense/ta-p/2155...

[lring]

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]

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.