Explore functions reference

Return to top

40 Comments

  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi CJ Johnson, you can find more about VALUE and D_COUNT in the article Choosing metric aggregators. Hope that helps!

    1
  • Dekbi
    Zendesk Customer Care
    Hi CJ,
     
    You may refer to the article Choosing metric aggregators to know more about "VALUE' and "D_COUNT".
     
    You may also use that article to learn about the different aggregators you can use, and how to use them.
     
    Also, for customer metrics, you can change the default aggregator by referring to Setting a metric's default and visible aggregators.
     
    I hope this helps.
    0
  • Crawford Philleo

    Should START_OF_WEEK_ISO (and END_OF_WEEK) be returning the start/end of the week based on your account settings? I think this is pulling back Sundays and Saturdays respectively for our account, but I assumed it would be updated based on the specific to the day you select in your account settings per your recent feature upgrade: https://support.zendesk.com/hc/en-us/articles/4418307079322#h_01FTH5XEE308FMZD440QX51AZ1

    0
  • Shehryar Khaliq Lodhi

    Is there a way we can achieve the 'subject of triggers fired on chats' like we can escalate that which trigger was used in the most in the chats? the customer interacted with is there a way to achieve?

    0
  • Dekbi
    Zendesk Customer Care
    Hello Shehryar,
     
    At this time, unfortunately, we don't support reporting for Chat Triggers. What I recommend is to add a custom to every trigger and report on them. 
     
    For your reference: Reporting with tags
     
    I've taken a look and found that other users are discussing similar needs here: Reporting on chat triggers
     
    You can up-vote that original post and add your detailed use-case to the conversation. Threads with a high level of engagement ultimately get flagged for product managers to review when they go through roadmap planning.
     
    Specific examples, details about impact, and how you currently handle things are the most helpful things to share to help our product teams understand the full scope of the need when working on solutions.
     
    We truly value customer feedback and your voice and votes on the product feedback topics in the community help influence future Zendesk functionality.
    0
  • CJ Johnson

    Does CONTAINS support multiple arguments? I'm looking for the equivalent to INCLUDES_ALL, but for possible field values for a numeric custom field. I want to say "if the value is one of these IDs, then return TRUE". I'm just not sure if I've hit a bug or CONTAINS can only support a single string to search for. 

    EDIT: ARRAY is what I really wanted. I found an example in another article, that shows how to use it a little more clearly and it does the trick: 

    (IN([Ticket created - Day of week],ARRAY("Monday", "Tuesday","Wednesday","Thursday","Friday")
    1
  • Bobby Koch

    Is there a way to build a metric that looks for public replies on assigned tickets, if the public reply was within the last 3 days? 

    0
  • Dave Dyson
    Zendesk Community Manager
    Hi Bobby, I see you'd posted a more detailed version of this question elsewhere -- I'll see if we can get an answer for you there.
    0
  • Holli Kyle

    Hi there! I've read through the comments here and got a bit further however for some reason my fixed metric is returning a different result from when I filter the data. For the date range, I even tried using DATE_GREATER_OR_EQUAL(Ticket created - Date],"2022/01/01") AND DATE_LESS_OR_EQUAL([Ticket created - Date],"2022/12/31") and got the same exact result however with this format I was at least able to change the dates to see them update to make sure it was working. I'm just not sure why the filter would result in such a hugely different number than the fixed formula?

    0
  • Dane
    Zendesk Engineering
    Hi Holli,
     
    I will have to directly check your query to determine what could be causing this data discrepancy. 
     
    I have created a ticket for you, please wait for my update via email.
    0

Please sign in to leave a comment.

Powered by Zendesk