I am a small MSP and I need to be able to get a list of resolved and closed tickets at the end of each month for billing.
The filters do not seem to allow me to just get a list of resolved/closed tickets for the month.
On top of that there seems to be no way to get a number from the tickets list for billable hours.
Any suggestions?
Best answer by BrynCYDEF
Hi
Back to closed tickets in month. You may prefer to have each company get their own report so set a Report Level Filter for the Department/Company Name.
Presumably you’ve created your report for: Tickets module
Then you’ve added a widget
Then click the pencil to edit the widget from the report page.
Then on your 1st metric (Total Tickets which you can rename btw) hit the pulldown arrow to set the (3) Date Range Dimension = Created Date which you then apply at the Report Level so you can restrict to Last Month
On the metric or on the Widget you can add other filter(s) as desired (2) e.g Status = closed or resolved ( You could even add a 2nd metric with the closed count and leave the Total Tickets in there)
Then add your Group by (4) - type in Department (5) because that’s how its called then select Name (6)
In 750 easy clicks you have 2 separate reports that probably have most of what you’re looking for. TahDah! 
Good Luck!
+16Hello
Here is a good place to start if you are new to analytics https://support.freshservice.com/support/solutions/articles/50000002911-getting-started-with-the-analytics-platform
I was able to get that far but that seems like more clicks than necessary. Especially since I can’t build off of that data and make reports as I can’t group by company either.
Hi
Back to closed tickets in month. You may prefer to have each company get their own report so set a Report Level Filter for the Department/Company Name.
Presumably you’ve created your report for: Tickets module
Then you’ve added a widget
Then click the pencil to edit the widget from the report page.
Then on your 1st metric (Total Tickets which you can rename btw) hit the pulldown arrow to set the (3) Date Range Dimension = Created Date which you then apply at the Report Level so you can restrict to Last Month
On the metric or on the Widget you can add other filter(s) as desired (2) e.g Status = closed or resolved ( You could even add a 2nd metric with the closed count and leave the Total Tickets in there)
Then add your Group by (4) - type in Department (5) because that’s how its called then select Name (6)
In 750 easy clicks you have 2 separate reports that probably have most of what you’re looking for. TahDah!
Good Luck!
Thanks for that, I reached out to support and they helped create exactly the widget you suggested.
Analytics has a lot of small tweaks that need to be made to make it work better for MSPs
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
