N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
This app package contains dashboards with different views on active and closed tickets as well as important KPIs used to gauge the team's effectiveness in resolving tickets. The widgets included will enable users to monitor day-to-day team performance and can be used for business reviews to provide insights.
List of Dashboards
Dashboard Name | Description |
---|---|
Active Tickets Summary | This dashboard shows the count of active tickets per board, per status, and per date created. In addition, it gives full visibility of ageing tickets with respect to creation date and date of last update. |
Ticket KPIs | This dashboard shows the monthly trend of relevant KPIs for open and closed tickets such as Ave. Time to Respond and Ave. Time to Resolve. All of these are also shown per customer for easy investigation. |
Tickets Resolved - Technician Efficiency | This dashboard gives an overview on count and daily rate of Tickets Resolved for the selected date range. Also shows the % of tickets resolved by First Line Response. |
Tickets Opened-Closed Same Day | This dashboard shows the count and percentage of tickets that were opened and closed on the same day as well as their weekly trend for the selected date range. |
Ticket Labor Analysis | This dashboard compares the total ticket count with the total labor hours on a per company, board, and subtype level. It also shows their monthly trend for the selected date range. |
Terms and Calculations
Terms | Definition/Calculation |
---|---|
Ticket Age | For active tickets, calculation is Current Date - Date Opened |
Tickets Resolved | Count of all tickets with a Date Resolved or Date Completed (if date resolved is not available) |
Average Labor Entries | Average count of time entries per ticket |
Average Labor Hours | Average number of hours recorded per ticket |
Closed First Contact | Closed tickets that only have 1 or 0 recorded time entry. Excludes time entries with less than 3 minutes |
First Line Response | Closed tickets that only have 1 recorded time entry. Excludes time entries with less than 3 minutes |
Single Technician on Ticket | Closed tickets with only 1 technician that logged time. Excludes time entries with less than 3 minutes |
Multiple Technician on Ticket | Closed tickets with 2 or more technicians that logged time. Excludes time entries with less than 3 minutes |
Reopened Tickets | Tickets that were reopened, meaning it was tagged as closed at one point but was changed to open/in-progress again. |
Avg. Time to First Time Entry | Average number of hours it takes before the first time entry is recorded per ticket. |
Avg. Time to Respond | Average Respond time (in Hrs) per ticket (data from ConnectWise Manage internal SLA) |
Avg. Time to Plan | Average Resolution Plan time (in Hrs) per ticket (data from ConnectWise Manage internal SLA) |
Avg. Time to Resolve | Average Resolve time (in Hrs) per ticket (data from ConnectWise Manage internal SLA) |
Opened/Closed Same Day | Tickets with same date opened and date closed |
Active Tickets Summary
This dashboard shows the count of active tickets per board, per status, and per date created. In addition, it gives full visibility of ageing tickets with respect to creation date and date of last update.
Available slicers are: Board, Team, Technician, and Date Range
Ticket KPIs
This dashboard shows the monthly trend of relevant KPIs for open and closed tickets such as Ave. Time to Respond and Ave. Time to Resolve. All of these are also shown per customer for easy investigation.
Available slicers are: Board, Team, and Date Range
Tickets Resolved - Technician Efficiency
This dashboard gives an overview on count and daily rate of Tickets Resolved for the selected date range. Also shows the % of tickets resolved by First Line Response.
Available slicers are: Board, Team, Technician, and Date Range
Tickets Opened-Closed Same Day
This dashboard shows the count and percentage of tickets that were opened and closed on the same day as well as their weekly trend for the selected date range.
Available slicers are: Board and Date Range
Ticket Labor Analysis
This dashboard compares the total ticket count with the total labor hours on a per company, board, and subtype level. It also shows their monthly trend for the selected date range.
Available slicers are: Board, Company, and Date Range