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 = [Change Progress] Booked into sprint
And an example report is structured as follows:
What (above metric)
Filters: the one relevant to this is Week (Mon-Sun)/Year (Event) is this week
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.
Please sign in to leave a comment.