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

random_user_098765
random_user_098765 Member
in Charting

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.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • random_user_098765
    random_user_098765 Member

    Your Solution worked! Thank you :)

Categories