I’ve just assumed that was a limitation in SuiteAnalytics. I change and use Period. Some records have a field called Month. Or create a formula field like TO_CHAR({date},’Mon’)

Can you get either of these options to sort correctly?

Me, never. Last time I tried some adaption on internal ID min assuming the transaction had been created in same date order.