Creating a Radar Chart Widget

This article shows how to create a radar chart widget. It applies to MSPbots users with an Autotask integration.

Below is an example of a radar chart widget: 

How to Create a Radar Chart Widget

1. Log in to MSPbots as an admin.
2. Navigate to Widgets on the MSPbots app menu and click New Widget. 
   
   
   
   
3. Select the Radar Chart widget type in the New Widget window. 
   
   
   
   
4. Fill in the following fields for Basic Setting.
   • Name - Give the widget a name.
   • Description - Give the widget a short description.
   • More Info
   • Role - Select the roles that will have access to the widget. The roles selected by default are Admin, User, and Dashboard Only. 
   • Tag
     
     
     
     
5. Click Apply when done. 
   
   
   
   
6. Click    to go to Dataset and click the + button.
   
   
   
   
7. Click New Layer.
   
   
   
   
8. In the Dataset window,
   
   1. Select the Dataset with the data you need. 
      
      
      
      
   2. (Optional) Enter a datasource name in the Show datasource name as field. 
   3. For Columns Display, 
      1. Go to the Column Name dropdown and select the field you want to show in the drill-through. 
         
         
         
         
      2. Give an Alias and select a Business Type for your selection. 
         
         
         
         If the selected Business Type is Number, read the article Options for Custom Formatting in Your Widgets and Dashboards for help with formatting numbers in your widgets. 
         
         
      3. Click the + icon to add more rows. 
         
         
         
         
   4. For Filter,
      
      1. Click the add    button and select Add Condition or Add Group. 
         
         
         
         
      2. Select the fields you want to filter.
      3. Set conditions for each field using the subsequent two dropdowns.
         For a guide on each option on the list, refer to What Filter Conditions and Formats are Available for Creating Widgets.
      4. Select the logical operator AND or OR for the filter group. 
         
         
         
         
   5. For Measure, 
      1. Click the + button corresponding to Measure. 
         
         
         
         
      2. In the Measure window, select a Summary Type.
      3. Select a Field to use in the computation.
      4. Enter an Alias for the measure.
      5. Select a Format Type.
      6. Click Add. 
         
         
         
         
   6. For Dimension,
      1. Click the add + sign corresponding to Dimension.  
         
         
         
         
      2. Click on Fields and select an option for grouping the data.
      3. Next, enter an Alias for the measure.
      4. Select a Format Type.
      5. Click Add.
         
         
         
         
   7. For DrillThrough Order By,
      1. Click the + icon. 
         
         
         
         
      2. Select a parameter to sort drill-throughs automatically. 
         
         
         
         
   8. (Optional) For Order By,
      
      1. Click the + icon. 
         
         
         
         
      2. Select a parameter to sort the data based on your selected field. 
         
         
         
         
   9. Row Limit - Select an option to set a limit on how many rows of data will be shown. (Optional) 
      
      
      
      
   10. Remove duplicate data - Select this option if you have duplicate data to delete. 
       
       
       
       
   11. Materialized - Select an option according to your requirements. 
       
       
       
       
   12. Click Save to keep the configuration. 
       

       Other optional settings:
       The following options are also available on the Dataset tab. When applied, these settings reflect on the radar chart instead of the drill-down.

       • • Order By - Sorts the data based on the selected field. 
         • Row Limit - Sets a limit to the number of rows that appear on the widget.  
           
           
           
           
9. Click Apply.
10. Move on to Config on the menu. 
    
    
    
    Do the following: 

    1. Select a Dimension to determine the parameter that will be the basis for the radar chart.

    2. Set a Measure to determine the parameters that will be included in the radar chart. Multiple measures can be selected.

    3. If the Show Axis Label switch is enabled, the radar chart will display the axis labels. This setting is enabled by default.
       Below is a radar chart with the Show Axis Label switch enabled.
       
       
       
       

11. Click Apply. This will show a preview of the radar chart.