Question
I have changed the date format in most parts of my report, however, the new format isn't taken into consideration in the datatips. How can I change the date format in datatips?
Answer
To alter the date format in datatips, create a standard calculated attribute and then add it to your report. If, for example, your report belongs to the tickets dataset and you are using the Ticket created- Date attribute, create a custom attribute with the below formula:
DATE_FORMAT([Ticket created - Date],"DD-MM-YYYY")
You can then modify the datatips in your report to include the modified attribute.
For more information, see the article: Working with datatips.
7 comments
Justin
Hey 1903250013624!
There are a couple of ways to get around this, and achieve what you're looking for. Going off of using the custom attribute Dave mentioned previously, you can create an ordered set to order these displayed values chronologically.
Another solution to abbreviating the dates and sorting in chronological order would be to use a time based, date attribute (i.e. Ticket Created - Date). If you apply this attribute to your query, you will be able to change the date format displayed in the query by going to Chart Configuration>Date Display Format and choosing a custom date format. To get the first 3 letters of the month and the year, you will want to enter the following into that field:
MMM YY
I hope this helps!
0
Jon Bierma
Hi 1263082116169 and 1263169421570 - using "Mon" does provide the month's 3-letter abbreviation, but when used in Explore in a graph, the data is sorted on the axis in alphabetical order of months instead of chronologically. This can't be resolved using the Sort settings. Is there any way around this?
0
Dave Dyson
1
Stephen Belleau
1265100791449 turns out there is a way! MON (or mon or Mon, whatever case you prefer)
1263082116169 can we add this to https://support.zendesk.com/hc/en-us/articles/4408834558746-Explore-functions-reference#topic_esm_5qg_dhb please? 😊
1
Dave Dyson
There isn't an argument you can supply to the DATE_FORMAT function that will give you the first three letters of the month, so you'll need to create a Standard Calculated Attribute with the following as the formula:
LEFTPART(MONTH([Ticket created - Date]),3)+"-"+YEAR([Ticket created - Date])
Hope that helps!
0
Rockford Hipp
I am having trouble generating the three-letter month name abbreviation. Is "MMM-YY" possible in Zendesk? Can I not do this because Explore wouldn't know how to sort in ascending order along a given axis? Thanks!
0
Richard Rijo Almeida
Olá Frank !
Agradeço pelo excelente artigo e me ajudou muito. Com base na orientação, fiz uma pequena alteração para ajustar a fórmula no idioma português e informar o carimbo com data + horário de criação.
0
Sign in to leave a comment.