I'm a bit stuck (and mods, apologies but I have posted this within another post, but wasn't descriptive enough).
In Insights I had/have the following custom metric in a very simple report, used across a few reports:
SELECT # Ticket Updates WHERE [Text Field] New Value =
I can't seem to find a similar variant to count the number of times this field was updated to that particular drop-down selection in Explore; there's a lot of advise on IF THEN ELSE, but that's not what I'm after.
Are you able to point me in the right direction? I haven't a clue how to achieve this.