u/stuckinCPD

Hi all- im in a bit of a pickle trying to figure out a clean way to display a lot of data points for my stakeholders.
The main request is to show all the types of tickets we get within the org. The main issue is there are 20+ unique ticket groups (departments) each with a custom field called tasks. SH wants to see all these tasks with volume and resolution time avg per task.
As far as I could tell there is no clean way to have this all in one report. SH does not want to have to export and they wish to have it on a dash where they can easily adjust times/status/groups to the given need.
Ideally we want a pivot style table with groups and the tasks listed all in a single column but it doesnt look like that is possible?
Any help is appreciated!