I am trying to build a report, which shows different metrics around tickets in the on-hold status (which we escalated internally and where we are waiting for bugs to be fixed, etc.).
As part of the summary header, I am currently trying to build a query, which only shows the date of the single oldest ticket (on-hold status).
I built a query to
Rows: Ticket Created - Date
Filter Ticket Status for "Hold"
From the resulting table, I only need that one date of the oldest ticket – not # of tickets, etc.
Any idea how I can narrow this down, e.g. with a custom Standard calculated metric?
Please sign in to leave a comment.