Creating standard calculated metrics and attributes

Have more questions? Submit a request

7 Comments

  • Jacob J Christensen
    Comment actions Permalink

    I'd like to have my ticket ID's in a table view hyperlink to the ticket url (like it does out of the box in GoodData), but I can't figure out the syntax for achieving that with a Standard calculated attribute. Can you help me out? Thanks. 

    1
  • Rob Stack
    Comment actions Permalink

    Finally, here's the link to the new recipe for clickable links - https://explore.zendesk.com/hc/en-us/articles/360002084927-Explore-recipe-Configuring-clickable-links-to-tickets

     

    1
  • Jacob J Christensen
    Comment actions Permalink

    Thanks a lot Rob!

    1
  • Rob Stack
    Comment actions Permalink

    Hi Jacob, I'll make sure to forward that request onto the correct folk. Rob

     

    1
  • Rob Stack
    Comment actions Permalink

    Hi Jacob, I'm working on a recipe for doing exactly this, and it should be released sometime next week. 

    However, as a teaser, try this formula:

    LINK("https://support.zendesk.com/agent/tickets/"+[Ticket ID],[Ticket ID])

    Replace 'support.zendesk.com' with your own subdomain.

    Also, in the chart configuration menu, choose Chart > Text Interpretation, and choose HTML.

    Finally, on the same page make sure that Clickable URL is checked.

    This is still in draft, so is unsupported, but hopefully gives you a starting point. 

    1
  • Scotty Loewen
    Comment actions Permalink

    I'm about ready to give up, so maybe someone has had a similar idea. I'm looking to generate a time series of how many agents took chats per each hour of the day, this would give me my actual staffing that day. 

     

    Has anyone tried to do that? I've tried creating a Calculated metric with DCOUNT_VALUES[Agent Name] but it acts funny, like I can't graph it by adding the hour started column, it just gives me the same number for each hour. I feel like I'm close, but I'm just missing something. I'm sure I could wrangle the SQL, but I can't get this. 

    0
  • Jacob J Christensen
    Comment actions Permalink

    Awesome! That works from the web UI, will it be possible - at some point to also have it available in exported reports? PDF's and Excel is what I'm thinking.

    Thanks Rob!

    0

Please sign in to leave a comment.

Powered by Zendesk