How to sort Month and Weekday properties in chronological order?

With the release of Data Query Piano Analytics, the Month and Weekday properties adopted the alphanumerical format.

• The Month property indicates the month of the measurement date: January, February, etc.

• The Weekday property indicates the weekday of the measurement date: Monday, Tuesday, etc.

As with all alphanumerical properties, the interface enables sorting in alphabetical order. As this sort does not correspond to the chronological order, we have created two additional properties: Month number and Day number.

• The Month number property indicates the measurement date month number (from 1 to 12).

• The Day number property indicates the day number of the measurement date (from 1 to 7).

You can therefore use a numeric property to apply a chronological sort to your analysis:

Sorting applied to the Weekday property→ Alphabetical order

Sorting applied to the Day number property → Chronological order

It is then possible to hide the numerical property.