I’m currently working on RT Dashboards for management reports.
I have the following challenge:
I need a feature for my dashboard that returns every user owning at least one ticket and the number of tickets he owns.
Any hint on how to accomplish this is greatly appreciated!
Currently I open every queue, sort by owner, count the tickets by hand and add them to an Excel file.
That’s not something I want to keep on doing
Best regards,
Andreas
– Update –
I’m able to perform the requested operation by creating a search for every ticket != resolved and going into “Chart” and selecting “Group by owner”. The resulting chart is exactly what I’d like to embed in my dashboard. But how?
– Update 2 –
I was successful!
On the chart sub-menu you can save the chart as root. This saved chart shows up for the dashboard along with the saved searches.
I tried this; perform the search, crate a graph, group by owner, calculate ticket count, select table. It works but it only show the ticket count for every member, it doesn’t show the name of the member: I attached a screenshot below
Am I doing something wrong?
We are using version 4.4.3
thanks for the fast reply. Unfortunately, that is not the issue. The display column includes Owner (and Owner name). To make sure, the issue is not because the RT version is a bit older (4.4.3), right? The search shows all the information, so that is not the issue, it’s only when creating the table it only shows the ticket count. I don’t think I’m forgetting anything in the chart settings: