hello,
I need to make a dashboard to include rolling reports
I need the below based on tickets solved per assignee
day by day rolling
week by week
month by month
quarter by quarter
3 month rolling
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
You can create a report with the native Solved tickets metric in the Support: Tickets dataset, and apply a date range filter for solved date.
You can create separate reports sliced by Ticket solved date attributes – each report sliced by a different combination of date attributes. For the day by day report, you can use Ticket solved - Date under Rows/Columns or by Ticket solved - Day of Month and Ticket solved - Month. Example:
For the other reports, you can use the attributes Ticket solved - Week of year, - Month, and - Quarter.
You can add these reports to a dashboard and then add a dashboard filter for Assignee name. You can then select the Assignee name from the filter dropdown to see the data per agent.