We do some reports on ticket lifecycle. Our problem is one gets only data for now, not for historic states.
A ticket for a technical request will be opened in the queues support or sales (maybe other). They all go to support and will maybe moved to second level or a department at last.
Once a month we want to know how many tickets were opened in support and how many opened in sales. With the buildin reports you cannot solve this question or I am to blind to see.
Our bad solution is to pull the report every hour or like this and do a lot of datamangling once a month.
Has anyone an idea to solve the question: “How many tickets in any queue were opened in a specific queue”?