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!
Page History
...
An example of a radar chart widget:
How to Create a Radar Chart Widget
...
- Navigate to Widgets on the MSPbots app menu.
- On the Widgets tab, click My Widgets.
- Next, click the New Widget button.Under My Widgets, click New Widget.
- Select the Radar Chart widget type on the New Widget window.
- When the Widget Builder window opens, click Info on the menu.
- Provide the following under Basic Setting. 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.
- Click Apply when done.
- Next, go to Dataset on the menu.
- Under Data Source, Go to the Dataset tab and click the
Add Dataset buttonbutton.
- Select New Layer when the Add New Layer window opens. This action will bring up the Dataset window.
- On the Dataset window,
- Select the Dataset containing the information you want to use. Give a Name You can also give a name for the Datasource (optional).
- For Columns Display,
- Using Go to the Column Name dropdown , and select the field you want to show in the drill-through.
Click the
button to add more rows. 
- Give the column an Alias and select a Business Type for each.it. Do this for every row that you create.
If the selected Business Type is Number, please refer to: read the article Options for Custom Formatting in Your Widgets and Dashboards.
for help with formatting numbers in your widgets.
- Using Go to the Column Name dropdown , and select the field you want to show in the drill-through.
- For Filter,
- Click the button and choose between Add Condition and Add Group.
- Add all the fields you want to be filtered.
- Select a filter from the first dropdown list.
- Next, set Set a condition /or logic for each field using the next 2 two dropdowns. For a guide on each options, refer to: Refer to the article What Conditions are Available for Creating Widgets? for the descriptions of each condition.
- Repeat Steps ci to ciii to add more conditions.
- When you have added all the conditions you need, select the logical operator AND or OR Select a logical operator for the filter group (AND or OR).
- Click the
- For Measure,
- Click the
button to show the Measure window.
- On the Measure window, select Select a Summary Type.
- Select a Field to use in the computation.
- Give Enter an Alias for the measure.
- Select a Format Type.
- Click ConfirmThen click Add.
- Click the
- For Dimensions,
- Click the button.
- Click on Fields and select an option Select a field to be used for grouping the data.
- Give Next, enter an Alias for the measure.
- Select a Format Type.
- Click ConfirmThen click Add.
- Click the
- For DrillThrough Order By,
- Click the Click the
button. 
- Select a parameter . This will to automatically sort data according to the selected parameter without manual sortingyour selection.
- Click the Click the
- For Order By,
- Click Click the button.
- Select a parameter .Sorts to sort the data based on the your selected field.
- Click Click the
- Next, select a Row Limit- Sets to set a limit on how many rows of data will be shown.
- Remove duplicate data - Please choose whether or not to enable Remove Duplicate Data based on the specific situation.
- to the number of rows on your widget.
- Tick the checkbox for Remove duplicate data to delete duplicate data based on your set conditions.
- Then select an option from the Materialized dropdown tomaterialize data based on the actual conditions.
Materialized - Please select whether to materialize based on the actual situation.
- Click Save to keep the configuration.
are:Tip Other optional settings
on how many rows of data will be shown.:
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
- 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.
Click - to the number of rows that appear on the widget.
After adjusting the settings for these, click Apply to save the setup.
- to the number of rows that appear on the widget.
- Select the Dataset containing the information you want to use. Give a Name You can also give a name for the Datasource (optional).
Move on to Config on the menu.
Do the following:
Select a Dimension to determine the parameter that will be the basis for the radar chart.
Set a Measure to determine the parameters that will be
Select the Dimension. This will determine which parameter to base the radar chart on.
Set the Measure. This will determine which parameters are included in the radar chart. Multiple measures can be selected.
Select whether to open Enable the Show Axis Label (default is not open).
if open, then the radar chart will display the axis label.
if not, then it will not display.
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.
- Finally, clickClick Apply. This will show a preview of the radar chart created.
| Content by Label | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Overview
Content Tools