Export/Statistic: Create an overview - how many tickets from organisations

Fabian Karpf

Hello,

for the following question I haven`t found a solution until now.

 

Question:

I want to create an overview, that shows which customers (Organisations) have created how many tickets/requests in our service desk.

For example:

- We have 6 different service desks for different products

- Until now our customers have created more than 10.000 tickets

- I want to know, that customer A has created 100 tickets, customer B has created 50 tickets, customer C has created 150 tickets (...(

 

What´s the best way to get these informations? I´ve tried to export it, but there were only 1000 tickets in the export. Is the a simple way to create something like that, maybe on the dashboard?

 

Greetings,

Fabian

Jack Brickey

Hi Fabian,

indeed I see the value in this as well. Unfortunately, OOTB, you can’t use Organizations as a statistic type for any dashboard gadgets. I wish that was an option and hope it gets implemented. Here is what you could do...

• create unique filters for each org and use a gadget per filter
• use an addon, maybe easybi would work well and there may be others for sure
• setup a filter and subscription for say a weekly report, export to CSV and do a pivot table on orgs. The ugly part here is you have to translate the cryptic org number to the org name

BTw, here is one of the open suggestions you can vote/watch - JSDCLOUD-5348