We are currently running on Jakarta but moving to London in month and then Madrid by the end of the year.
But I have been asked to create a report to show the activity for all the Assignment groups we have. The plan is to decommission the assignment groups with no tickets that are not being used. But there doesnt seem to be a report that shows the ticket count of all assignment groups that don't have any tickets for all active assignment groups.
If there was a filter that says "tasks open" with variable being less than 1 against the assignment groups table that would be handy.
I heard people mention database views in the past but i dont know exactly how to do that. I know there are guides for database views. But i dont know how to use them to get to the data i need.
I have heard other people mention javascript. But again i dont know how you add this into a report to get to what i need.
Does anyone have any ideas here?
