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. 

[DRay]

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.