Hi, I’m trying to make a monthly overview statistics template. What I need, is a list of all tickets available in a specific month sorted by their status, no matter when they were created. E.g. on the last day of a month I have 30 total tickets open(available for work) and during the month I closed… lets say another 30. All of them were created in different queues, and most of them were created in the month before, or even earlier. How can I generate a list of (open, closed, new) tickets in THIS month, no matter when they were created?

 

I tried different things, like opened date, closed date in the stat module… but they only work for tickets in the month that they were created. SO if a ticket was created in January, but closed in February, it will be shown as a January closed ticket… so it doesn’t work for me.

 

Any help will be appreciated.

 

Best regards,

Alexander