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!


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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. Under My Widgets, click New Widget.
  3. Select the Radar Chart widget type on the New Widget window

  4. When the Widget Builder window opens, go to the Basic Setting tab. Provide the following and click Apply:
    • 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.
  5. Go to the Dataset tab and click the Add Dataset button.


  6. Select New Layer when the Add New Layer window opens. This action will bring up the Dataset window.
  7. On the Dataset window,
    1. Select the Dataset containing the information you want to use.
    2. Give a Name for the Datasource (optional).
    3. For Columns Display,
      1. Using the Column Name dropdown, select the field you want to show in the drill through. Click the  button to add more rows.  
      2. Give an Alias and select a Business Type for each.If the Business Type is Number, please refer to: Options for Custom Formatting in Your Widgets and Dashboards.

    4. For Filter,
      1. Click the button and choose between Add Condition and Add Group.
      2. Add all the fields you want to be filtered.
      3. Set a condition/logic for each field using the next 2 dropdowns. For a guide on each options, refer to: What Conditions are Available for Creating Widgets?
      4. Select a logical operator for the filter group (AND or OR).
    5. For Measure,
      1. Click the  button to show the Measure window.
      2. Select a Summary Type.
      3. Select a Field to use in the computation.
      4. Give an Alias for the measure.
      5. Select a Format Type.
      6. Click Confirm.
    6. For Dimensions,
      1. Click the button.
      2. Select a field to be used for grouping the data.
      3. Give an Alias for the measure.
      4. Select a Format Type.
      5. Click Confirm.

    7. For DrillThrough Order By,
      1. Click  the button.
      2. Select a parameter. This will automatically sort according to the selected parameter without manual sorting.
    8. For Order By,
      1. Click  the button.
      2. Select a parameter.Sorts the data based on the selected field. 
    9. Row Limit - Sets a limit on how many rows of data will be shown.
    10. Remove duplicate data - Please choose whether or not to enable Remove Duplicate Data based on the specific situation.
    11. Materialized - Please select whether to materialize based on the actual situation.
    12. Click Save to keep the configuration.
    13. Other optional settings are:
      1. Order By - Sorts the data based on the selected field. 
      2. Row Limit - Sets a limit on how many rows of data will be shown.
      3. The same 2 options are available on the dataset tab, the difference is that they apply to the radar chart shown instead of the drill-down.
    14. Click Apply to save the setup.
  8. Go to Config tab.
    1. Select the Dimension. This will determine which parameter to base the radar chart on.

    2. Set the Measure. This will determine which parameters are included in the radar chart.Multiple measures can be selected.

    3. Select whether to open the Show Axis Label (default is not open).

      1. if open, then the radar chart will display the axis label.

      2. if not, then it will not display.

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




  • No labels