Recent searches

No recent searches

Calculation with multiple results - Show First Result Only

Answered
image avatar

paultechpro

Posted Jan 18, 2021

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]
ENDIF

Many 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?

 

 

0

2

2 comments

Date
    image avatar

    Stephen Belleau

    Zendesk LuminaryCommunity Moderator

    @... - 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. 

    0

    image avatar

    Stephen Belleau

    Zendesk LuminaryCommunity Moderator

    @... actually there might be a better way. See @...'s comment here: https://support.zendesk.com/hc/en-us/articles/360022364653/comments/1260800152970

     

    0

    Post is closed for comments.

    Didn't find what you're looking for?

    New post