Sorting Heatmap by Month-Year Concat on y-axis and Day of Month on x-axis

random_user_098765

Hello,

I have a heatmap that on the x-axis has the Day of the Month and on the y-axis has the month and year concatenated, i.e. January 2022. My question is how can I order the axes in such a fashion that I get the most recent month and year concatenation at the top of the y-axis and have the rest of the month and year concatenations continue in descending order and then have the days of the month on the x-axis start at 1 and increase until 31?

I have thus far tried concatenating the year and the month number to try to sort the month and year concatenation in a beast mode below but I have nothing popping up.

case when MONTH(DAY) < 10 then
CONCAT(YEAR(DAY),0,MONTH(DAY))*1
else CONCAT(YEAR(DAY),MONTH(DAY))*1
end

The solution would have to be done in a beast mode but I am open to trying any proposed beast modes.

GrantSmith

Is your Day field a date or is it a string?

If it's a date you can use two beast modes to set a sort order

Month sort

LAST_DAY(`Day`)

Put this in the sort and sort it descending

Day sort:

DAYOFMONTH(`Day`)

Then put this in the sort after the month sort and sort it ascending.