Can I report on user email domain in Explore?

Return to top

5 Comments

  • Carolyn Berlin

    I'm using this report and it works great except that drillthrough does not seem to be working. When I select the number (5) of users for one of the clients, then try to use drillthrough, it pulls all of the clients in the report instead of just the 5 for the relevant client selected.

    0
  • Elaine
    Zendesk Customer Care

    Hi Carolyn,

    As of the moment, calculated metrics and attributes are currently not supported in using the Drillthrough interaction. You can check on the article Using drillthrough to refine your results for more information.

    I highly recommend upvoting this Feature Request: Add calculated attributes to Drill-Through.

    Hope this helps! Cheers! :)

    0
  • Russ Milton

    Hello,

    I've tried using these steps to create a query to show a COUNT of tickets sent by each domain on our Zendesk Instance.

    However, this always hits the 50,000 rows error and therefore I don't get a full count of tickets per domain. We've close to 200,000 tickets on our instance currently so it seems it has to calculate the first 50,000 tickets before it can apply the filter. 

    Is there a way around this? We don't have Organisation domains set up since we have multiple Organisation Sites that use the same domain.

    1
  • Basyl Durnan

    I struggled a bit with the above advice. I ended up making a Calculated Attribute for our needs with the below formula, which appears to be working well.

    RIGHTPART([Requester email],(LENGTH([Requester email]))-(FIND([Requester email],"

    Really feels like something Zendesk should have out of the box. We didn't want to bother setting up Organization Names for all of our users, since that is a lot of manual ongoing effort.

    1
  • Eugene Orman
    Zendesk Product Manager

    The better formula for the Email client attribute is simply:

    REGEXP_EXTRACT([Requester email],"[^@]+$")
    0

Please sign in to leave a comment.

Powered by Zendesk