Creating report of internal ticket usage by user?

[fstjohn]

I apologize if this has been covered but we are looking to create a report showing which employees utilize the resources of a given service pipeline (in this case; Service Tickets of Marketing Requests).

I attempted to sort the incoming request by "Associated Contacts" but that doesnt appear to be an option - any insight would be very appreciated

[deepikaverma]

Hi @MiaSrebrnjak - Thanks for tagging me in the post. Happy to help!

[fstjohn]

thank you so much for taking the time to help! In our case, since its an internal pipeline (where dozens of sales reps can make requests of 2 or 3 members of the marketing team) both sides are employees. And the goal isnt so much to reveal who is fielding the tickets as owners, but making requests and using marketing's resources - and the only field I see for that is "Associated Contacts"

[deepikaverma · Accepted solution]

Hi @fstjohn ,
I believe here emplyoee you are reffering to is "ticket owner", if it is so then there are two ways of doing it
- In main fliter specify the "ticket owner"
- And in data filter use pipeline and count of ticket ( It will show us the number of tickets are assigned in a pipeline)

- Adding the snapshots of the same.

Other way out is as below
-In main filter specify the pipeline
-In visualization section - use Ticket owber vs count of contacts

Please let me know if you have any questions!

[MiaSrebrnjak]

Hi @fstjohn, 

Thank you for reaching out to the Community!

I wanted to tag in a couple of subject matter experts to see if they have any advice: 

Hi @Jnix284, @deepikaverma, @Dan1, do you have any tips for @fstjohn? Thank you!

Cheers
Mia, Community Team