最近搜索

没有最近搜索

Calculation with multiple results - Show First Result Only

已回答
image avatar

paultechpro

已于 2021年1月18日 发布

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 条评论

日期
    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

    帖子评论已关闭。

    找不到所需的内容？

    新建帖子