Custom Format for MINUTES (display X h X m)

4 コメント

  • Walter Bellante
    Zendesk Product Manager

    Thanks for sharing your feedback about Explore.

    It is possible to format dates by using the "DATE_FORMAT" function (Learn more here)

    As an example, if you wanted to display the ticket creation time with the format you mentioned, you can use the following syntax on the "Standard Calculated Attribute":

    DATE_FORMAT([Ticket created - Timestamp],"hh h mm m")

    I hope this helps.

  • Jens Herlevsen

    I would really like to see this as well. This was easy to do in gooddata but so far does not seem to be possible in Explore.

    @... This is not a date, its a duration, eg. a number of seconds/minutes/hours etc.

  • Dan Ross
    Community Moderator

    Definitely looking for this functionality on duration data types as well. 

  • Jack Rausser

    +1 Dan Ross



Powered by Zendesk