Security, Privacy, AI and CSR information for all Piano products now lives in one place. Explore our Compliance Center.
Analytics
English French
English French

How to sort Month and Weekday properties in chronological order?

Sort on the numeric property that goes with each one: Month number for Month, and Day number for Weekday.

The Month and Weekday properties contain text, so they sort alphabetically ("April" comes before "January", and "Friday" before "Monday"). The numeric properties give you the chronological order.

Property

What it shows

Month

The month of the measurement date: January, February, and so on

Month number

The month number, from 1 to 12

Weekday

The day of the week of the measurement date: Monday, Tuesday, and so on

Day number

The day number, from 1 to 7

  1. Add the text property (Month or Weekday) and your metrics to your report.

  2. Add the matching numeric property (Month number or Day number).

  3. Sort the report on the numeric property. The text property now appears in chronological order.

image-20261014-083417.png


Last updated: