Cannot sort by months in Adhoc View
search cancel

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.