Emma Kane

This has worked! It corresponds to my Insights data perfectly. 

Our internal Zendesk guru is on maternity leave so this has been a bit of a struggle!

Thanks ever so much Chandra! 

Emma

Thanks Graeme - I've followed this and it does seem logical, however no data is returned at all, which isn't right. 

This is the only metric my reporting is reliant on, so I'll do some digging and hopefully it'll be something that I can work out. 

Hi there, 

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.

Thanks, 

Emma

Hi there, 

I'm facing a similar issue here. In Insights I had/have the following custom metric:

SELECT # Ticket Updates WHERE [Text Field] New Value = [Change Progress] Booked into sprint

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'm a bit lost!

Thanks, 

Emma