Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

radar chart

How to Create a Radar Chart Widget

  1. Navigate to Widgets on the MSPbots app menu.
  2. On the Widgets tab, click My Widgets.
    my widgets
  3. Next, click the New Widget button.
    new widget
  4. Select the Radar Chart widget type on the New Widget window
    radar chart
  5. When the Widget Builder window opens, click Info on the menu. 
    widget builder
  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.
      basic setting

  7. Click Apply when done. 
    apply basic setting
  8. Next, go to Dataset on the menu. 
    widget dataset
  9. Under Data Source, click the button.
    add dataset
  10. Select New Layer when the Add New Layer window opens. This action will bring up the Dataset window.
    new layer
  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).
      select dataset
    2. For Columns Display,
      1. Go to the Column Name dropdown and select the field you want to show in the drill-through.
        column name
        Click to add more rows. 
        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.
        add condition
      2. Select a filter from the first dropdown list. 
        select field
      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.
        set 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.
        logical operator
    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.
        measure fields
    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.
        dimensions fields

    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
        order by
      2. Select a parameter to sort the data based on your selected field. 
        order by parameter

    8. Next, select a Row Limit to set a limit to the number of rows on your widget. 
      row limit
    9. Tick the checkbox for Remove duplicate data to delete duplicate data based on your set conditions. 
      remove duplicate
    10. Then select an option from the Materialized dropdown tomaterialize data based on the actual conditions.
    11. Click Save to keep the configuration.

      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. 
      radar chart axis label

      This is how the radar chart looks like when the Show Axis Label switch is disabled. 

      radar chart no axis

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


Content by Label
titleRelated Topics
cqllabel = "widgets"