How to Show Months in Chronological Order (Jan–Dec) in Platform Analytics Report?

[Vaishnavi B]

Hi,

We’ve created a report in Platform Analytics with a condition:
"Created via Touchpoint" is True.

In the Date filter, when I select "Last 12 months", the report shows the months either in ascending or descending order, based on the sort options available — like alphabetically (e.g., April, August…) or by value.

Is there a way to display the months in proper chronological order, i.e., January to December, regardless of the data values?

Any suggestions or workarounds to achieve this would be appreciated.

Thanks!
Vaishnavi

[Omkar Kumbhar]

Hello @Vaishnavi B ,

you can use a scripted breakdown or indictor to include a field like month Number (1-12) along side the month name then, sort the report by month number and display label as the month name.

(function transform(item) {
var monthNames = ['January', 'February', 'March', 'April', 'May', 'June',
'July', 'August', 'September', 'October', 'November', 'December'];
var monthIndex = item.getValue('sys_created_on').getMonth(); // 0-based index
return monthNames[monthIndex];
})(item);

OR

if you are using a breakdown for months you can create a breakdown source that includes months as static value

• Add 12 entries manually:
  • January (Order: 1)
  • February (Order: 2)
  • ...
  • December (Order: 12)

and assign a sort order to each month and use this breakdown in your report

[Vaishnavi B]

Hi @Omkar,
Thanks for your response! I actually meant Platform Analytics reports, not Performance Analytics — that was a typo on my part.
Do you know if showing months in chronological order (Jan to Dec) is possible in Platform Analytics?

Appreciate your help!