Yes, you can display the month as a three-letter abbreviation in Zendesk by using theDATE_FORMAT
function with the formatMon DD YYYY
. This will return the date with the month abbreviated to three letters, such as 'Mar 21 2022'.
However, be aware that using this format in a graph may result in the data being sorted alphabetically rather than chronologically. To address this, you can create an ordered set to ensure the months are displayed in the correct order.
To change the date format in datatips, you need to create a standard calculated attribute and add it to your report. For instance, if your report uses the Ticket created - Date attribute, you can create a custom attribute with the formula:…
To sort months chronologically when using three-letter abbreviations, you can create an ordered set to display the values in the correct order. Alternatively, you can use a time-based date attribute, such as Ticket Created - Date, and adjust the…
To create a custom date format in Zendesk, you can use theDATE_FORMAT
function. For example, to format a date as 'DD-MM-YYYY', you would use the formula:DATE_FORMAT([Ticket created - Date],"DD-MM-YYYY")
. This allows you to customize how dates…
Yes, you can use the 'MMM-YY' format in Zendesk Explore by applying a time-based date attribute and adjusting the date format in the Chart Configuration settings. EnterMMM YY
in the Date Display Format field to achieve this format. This allows…