Cannot sort by months in Adhoc View

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• An adhoc view is created under Advanced Reporting, in Clarity
• Its of type Crosstab
• Investment Name is defined on the Y-axis
• Investment Date Start Month is defined on the X-axis
• At this point, it is noticed that the X-axis does not get sorted correctly. That is from Jan to Dec. It instead gets sorted Alphabetically, from Apr.

Resolution

• The field used in the X-axis is a String type field
• Use a Date type field to get the correct sorting order.