Formatting Ticket Created date along X-axis



  • Stephen Belleau
    Community Moderator

    You can do this with a custom attribute. But be aware, you can't filter a custom attribute by floating date ranges. So you need to:

    1. Remove your Ticket Created - Year/Month columns. Since those have your current filters, you'll want to add Ticket created - Date as a filter for your desired ranges.

    2. Create standard calculated attribute:

    DATE_FORMAT([Ticket created - Date],"Mon 'yy")

    Check "Sort like time attribute" box

    Save and add to column.

    3. When I created this, I noticed despite setting "Sort like time attribute", it still wasn't sorting properly. I had to go to Result Manipulation > Sort > Value descending.


Please sign in to leave a comment.

Powered by Zendesk