Cannot sort by months in Adhoc View
book
Article ID: 383594
calendar_today
Updated On:
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.
Feedback
thumb_up
Yes
thumb_down
No