Hi, I am kinda new in explore and attempting to create a ticket aging report for the unsolved tickets. The desired output would be a report with the tables that have columns (ticket ID, Assignee, and the ticket age), something like below image;
I have created standard calculated metric as follow;
IF ([Ticket status - Unsorted] != "Closed" OR [Ticket status - Unsorted] != "Solved") THEN TODAY() - [Ticket created - Date] ENDIF
in hope I will get the aging formula result for each ticket, but now stuck on how to show this in the column.
If anyone can provide some insight it would be much appreciated. Thanks!