Page History

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

An example of a radar chart widget:

How to Create a Radar Chart Widget

1. Navigate to Widgets on the MSPbots app menu.
   
2. On the Widgets tab, click My Widgets.
   
   
3. Next, click the New Widget button.
   
   
4. Select the Radar Chart widget type on the New Widget window. 
   
   
5. When the Widget Builder window opens, click Info on the menu. 
   
6. Provide the following under Basic Setting.
   
   • Name - Give the widget a name.
   • Description - Give the widget a short description.
   • Role - Select or edit the roles that will have access to the widget. The roles selected by default are Admin, User, and Dashboard Only.
     
     
     
7. Click Apply when done. 
   
8. Next, go to Dataset on the menu. 
   
9. Under Data Source, click the button.
   
   
10. Select New Layer when the Add New Layer window opens. This action will bring up the Dataset window.
    
11. On the Dataset window,
    
    1. Select the Dataset containing the information you want to use. You can also give a name for the Datasource (optional).
       
    2. For Columns Display,
       1. Go to the Column Name dropdown and select the field you want to show in the drill-through.
          
          Click to add more rows. 
          
          
       2. Give the column an Alias and select a Business Type for it. Do this for every row that you create.
          
          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. For Filter,
       
       1. Click the  button and choose between Add Condition and Add Group.
          
          
       2. Select a filter from the first dropdown list. 
          
       3. Next, set a condition or logic for each field using the next two dropdowns. Refer to the article What Conditions are Available for Creating Widgets? for the descriptions of each condition.
          
       4. Repeat Steps ci to ciii to add more conditions. 
       5. When you have added all the conditions you need, select the logical operator AND or OR for the filter group.
          
    4. For Measure,
       1. Click the  button to show the Measure window.
          
       2. On 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. Then click Add.
          
    5. For Dimensions,
       1. Click the button. 
          
          
       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. Then click Add.
          
          
          
    6. For DrillThrough Order By,
       1. Click the button. 
           
       2. Select a parameter to automatically sort data according to your selection.
          
          
          
    7. For Order By,
       1. Click the button. 
          
       2. Select a parameter to sort the data based on your selected field. 
          
          
          
    8. Next, select a Row Limit to set a limit to the number of rows on your widget. 
       
    9. Tick the checkbox for Remove duplicate data to delete duplicate data based on your set conditions. 
       
    10. Then select an option from the Materialized dropdown tomaterialize data based on the actual conditions.
        
    11. Click Save to keep the configuration.
        

        Tip
        Other optional settings: The following options are also available on the Dataset tab. When applied, these two 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.   After adjusting the settings for these, click Apply to save the setup.

12. 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. Enable the Show Axis Label switch. This setting is enabled by default.

       Below is a radar chart with an enabled Show Axis Label switch. 
       
       
       This is how the radar chart looks like when the Show Axis Label switch is disabled. 

       
       
       

    4. Finally, click Apply. This will show a preview of the radar chart.