Hello,
I'm trying to format the date values shown on the X-axis for the Columns Ticket Created - Year and Ticket Created - Month. However, over in Configuration, I'm not provided any Date format options - I think Zendesk doesn't see these as date values.
Is there any way to format these dates differently? I just want it to say "Feb '21" for instance.
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.