End Users with Multiple Open Tickets

2 Comments

  • Graeme Carmichael
    Community Moderator

    Danielle

    That is a fun question. It looks like we can use the new aggregate functions here.

    Use the metric DCOUNT(Requesters) and filter by ticket status so that we are only looking at active tickets (OPEN, NEW,PENDING)

    Now create a custom attribute for our row to split the requester into buckets depending on the tickets they have. Best to use a Switch function.

    So you have something like this:

    To display as percentages, go to Results Manipulation>Result Path Calculation:

    1
  • Danielle Eberhardt

    Graeme Carmichael Thank you so much for the response! This was very helpful. I have a particularly large data set, so it took some filtering to render results, but I was able to recreate!

    Cheers!

    0

Please sign in to leave a comment.

Powered by Zendesk