I am trying to create a custom metric that would show how many tickets were changed from the status 'Solved' 'Pending' 'On-Hold' to 'Open' and I'm getting an error 'Unknown object (uri: Status)'
Could anyone take a look at this and see what I may doing wrong?
Here is the MASQL i'm using to create the metric:
SELECT count(Ticket Id, Ticket Text Field Change) WHERE Text Field = Status AND [Text Field] New Value IN [Status] open AND [Text Field] Previous Value = ([Status] solved, [Status] pending, [Status] hold) AND Ticket Status <> Deleted
Please sign in to leave a comment.