Explore recipe: Joining attributes

Return to top
Have more questions? Submit a request

6 Comments

  • Andrei Kamarouski

    Hi, 
    How do I get months following the real calendar order with this joined attribute Year/month (now they get by alphabet)? 

    0
  • Molly
    Zendesk Customer Success

    Hey Andrei,

    When combining the attributes like so, Explore sees it as a string and not as a time attribute. My recommendation for looking at the Year/Month in order would be to stack the attributes like so:

    1
  • Andrei Kamarouski

    Hi Molly, 
    This is clear. Thank you! 

    0
  • Jason Brown

    Hello,

    I am trying to combine fields where sometimes one is null, is there any way to detect if its null and if so, replace it with a different value so that the result is not "Null"?

     

    2
  • Robert DelFave

    Hello,

    I am trying to combine an IF THEN with Full Resolution times of the IF THEN statement. Whats the best way to do this? Here is what I am currently working with:

     

    IF (INCLUDES_ALL([Ticket tags], "engage_squad","intercom_chat")) OR (INCLUDES_ALL([Ticket tags], "engage_squad","intercomchat"))
    THEN [Ticket ID]
    ENDIF

    0
  • Eugene Orman
    Zendesk Product Manager

    Hi Robert,  

    If you want to return Full resolution time instead of the count of tickets the formula will be: 

    IF (INCLUDES_ALL([Ticket tags], "engage_squad","intercom_chat")) OR (INCLUDES_ALL([Ticket tags], "engage_squad","intercomchat"))
    THEN VALUE(Full resolution time (hrs))
    ENDIF

    0

Please sign in to leave a comment.

Powered by Zendesk