Explore recipe: Due date performance report

Have more questions? Submit a request

2 Comments

  • Alessandra Cesari
    Comment actions Permalink

    Hi, I am trying to calculate the number of days from Ticket creation to when it was updated last, I have created the following metric

    DATE_DIFF([Ticket updated - Timestamp],[Ticket created - Timestamp],"Last Updated (days)"

    But the query displays no result

    Can you help?

    0
  • Graeme Carmichael
    Comment actions Permalink

    Alessandra

    Try this:

    • DATE_DIFF(TODAY(),[Ticket created - Timestamp],"nb_of_days")

     

    0

Please sign in to leave a comment.

Powered by Zendesk