Page History

The heatmap widget in the MSPbots dashboards is a graphical representation of data where values are depicted by colors (red, yellow, and green) to identify hot and cold spots in the data. These spots help determine and understand trends and behavior that are critical to business analysis and achieving goals.

An example of a heatmap widget:

Image Added

...

To make a heatmap widget for your dashboard: 

1. Login to the MSPbots dashboard and navigate to Widgets.
2. Click the New Widget button and select the Heatmap widget type. 
   Image Added
   
3. When the Widget Builder window opens, give the widget a Name. 
   Image Added
   
4. Next, add a Description. 
5. Then, select or edit the roles that will have access to the widget. The roles selected by default are Admin, User, and Dashboard Only.
   
   Image Added
6. Click Apply.
7. Proceed to configure the dataset by clicking the Datasource icon and then the + Add Dataset button.
   
   Image Added
8. Select New Layer when the Add New Layer window opens. This action will bring up the Dataset window.
9. On the Dataset window, select a Dataset to use.  Example: ConnectWise Tickets Statistics - Cloud 
   
   Image Added
10. Add and configure the Columns and Filters according to your business requirements.For example, if you want to show the count of resolved tickets in the last 14 days, select hours_actual

1.  Login to MSPBots.ai site 

2.  Hover to Widget menu.

3.  Click + New Widget button

4.  Select Heatmap widget

          Image Removed

5.  Add a Name and Description

Image Removed

6.  Add/Edit a Role (Default:  Admin, User and Dashboard Only)

Image Removed

7.  Click Apply

8.  Click the Datasource icon. Then, click + Add Dataset.

Image Removed

9.  Select a Dataset to use.  e.g ConnectWise Tickets Statistics - Cloud

Image Removed

...

1. , date_resolved, ticket_number, and resolved_by for the columns and filter by date_resolved in the last 14 days

...

1. . 
   

...

1. 
   Image Added

...

1. Add a function for

...

1. the columns

...

Image Removed

11.  Add and Setup Measure.  e.g. Ticket count

Image Removed

12.  Add and Setup Dimension.  e.g. for Actual Hours, Date and Resolved by.

13.  Click Save to save setup.

1. , if needed.
   1. Under Column Display, click the fx icon that corresponds to the column that requires a function. 
      
      Image Added
   2. Select an option for Field Formula and click Save. For example, for the hours_actual column, add a field formula to round off hours to return real hour values without a decimal.
   3. Repeat Step 11 for every column that needs a function.
      
      
2. Next, add and set up Measure. Measures are aggregates like sum, max, avg, and count. 
   Image Added
   For example, if you want to count the number of tickets, select count for Summary Type, Ticket Number for Fields, Ticket Count for Alias,
   and Number for Format Type.  Click Confirm to save this setting.
   Image Added 
3. Add and set up Dimension to group data.  Example: group by Actual Hours, Date, and Resolved by. 
   
   Image Added

4. Click Save to save the setup. 
   
   To sort and order the results on the heatmap widget 

   1. Click + Order By and select an option.
      
      Image Added
   2. Sort the results by choosing to show data in either ascending or descending manner by clicking the arrow shown in the following section of the window.
      
      Image Added
   3. Click Apply to save.
      
      
5. Next, set up the widget Configuration. Click the Config icon.
   Image Added
6. Set the chart value results for the x-y axis using the following guide:
   • A - Dimension - Select an option from the drop-down menu to label the x-axis value on the chart. Example: Select Date.
   • B - Measure - Select an option from the drop-down menu to label the y-axis value on the chart. Example: Select Hours.
   • C - Label - Select a label and give it a name. This is the specific value result shown in the chart. Example: Select Ticket count by Hours.
   • D - Show Label - Tick this checkbox to show the label results.
   • E - Min/Max Value -   The value set here will be the basis for the Minimum and Maximum value for the results. This also determines the color of the results. 
     
     Image Added
7. Set up Chart view using the following guide:
   • • F - Orient - Set the Heatmap Legend to horizontal  Image Added or vertical  Image Added
     • G -Grid Top - This is the percentage distance of the chart from the margin above it.
     • H - Left Side Distance - This sets the Heatmap Legend's location on the chart. Choose right, center, or left.
     • I- Bottom Side Distance - This is the percentage distance of the chart from the margin below it.
     • J - Is Total - Turn this switch ON to get the grand total of the rows and columns (X and Y axis). 
       
       Image Added
8. Click Save to keep the configuration. 
9. Finally, click Apply to apply all changes made to the widget.
   Image Added