Sorting rows in a Histogram

[Arnab_Dutta]

Hi, I am creating a histogram that groups a number by month. My month is saved as a text (Jan-20, Feb-20, March-20 etc.). The output displayed is sorting the months in alphabetical order starting with Apr-20. Is there a way to sort it in correct month order?

[MultiTech]

Hmmm… difficult.

Typically I’d say something like: “If you change the column type to Enum, and specify the options in the definitions, then the order of the options is used most the time for sorting.”

But since we’re talking about a histogram - and it sounds like this will need to be something fluid, meaning it should be able to adjust and grow based on values used, not needing to be “hard coded” like you would with an Enum column - I’m not sure what to use here.

Maybe try the Enum column and see if it works?

[Mike_T]

Not pretty but found a workaround to sort Histogram Chart. I’m using a Virtual Column to count the number of [Start Date]s I have per month. This is the formula I’m using in the VC:

Concatenate(Month([Start Date])," - ",INDEX(
LIST(
“Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun”,
“Jul”, “Aug”, “Sep”, “Oct”, “Nov”, “Dec”
),
MONTH([Start Date])
))

I end up with this: