I have a created a custom attribute that is currently returning the Update - Timestamp as requested, but would like to only see the first or earliest result.
IF ([Comment present] = TRUE
AND [Comment public] = TRUE
AND [Updater role] != "End-user")
THEN [Update - Timestamp]
ENDIFMany results will have multiple updates in them like this.
I know you are able to FILTER results, but is there any way to make it so that the calculation itself only returns a single result?
@Paul Smith - not sure how much this helps because I'm not sure what else you might be trying to do with your query. But you can use the Result manipulation > Top/Bottom to return only the Top 1 result, with metric = D_COUNT(# agent public comments) and strategy = On rows. I was able to get that to return only the earliest result.
@Paul Smith actually there might be a better way. See @Graeme Carmichael's comment here: https://support.zendesk.com/hc/en-us/articles/360022364653/comments/1260800152970
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.