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!
1. Login to MSPBots.ai site
2. Hover to Widget menu.
3. Click + New Widget button
4. Select Heatmap widget
5. Add a Name and Description
6. Add/Edit a Role (Default: Admin, User and Dashboard Only)
7. Click Apply
8. Click the Datasource icon. Then, click + Add Dataset.
9. Select a Dataset to use. e.g ConnectWise Tickets Statistics - Cloud
10. Add new columns and filters e.g. hours_actual (with round off function), date_resolved, ticket_number, resolved_by and filter by date_resolved in the last 14 days)
11. Add function for certain columns (if needed)
11. Add and Setup Measure. e.g. Ticket count
12. Add and Setup Dimension. e.g. for Actual Hours, Date and Resolved by.
13. Click Save to save setup.
7