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!

lring

Posted 1 year ago·Last reply 1 year ago

4 comments

DRay

·1 year ago

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.

DRay

·1 year ago

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.

lring

OP1 year ago

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

·1 year ago

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/21555#toc-hId-2010181851