Background information
The new Widget Builder integrates all widget configuration options on a single page.
- By centralizing the management of all configuration options, users no longer need to switch between various pages, saving time and effort, enhancing user experience, improving work efficiency, and simplifying the operation process.
- This integrated design is easy to use and makes the configuration process more intuitive and efficient.
When to use the Line Chart widget
The Line Chart widget is used to highlight key data and identify actionable items. It is very helpful when you want to visualize data trends and measure the impact of these trends on MSP operations and goals.
The Stacked Line Chart widget helps you visualize the relative contributions of different variables over a specified period of time. You can follow the steps to create a line graph and choose the Stacked Area Style option in the Design section of the MSPbots app to create this type of chart.
Required permissions
Only users with admin roles can access the New Widget Builder and edit the widget settings.
1. Access New Widget Builder
1.1 Create a new Line Chart widget using the New Widget Builder
- Navigate to Widgets on the MSPbots app menu and click New Widget.
- Choose the Line Chart widget type on the New Widget window.
1.2 Configure an existing widget using the New Widget Builder
- Navigate to Widgets on the MSPbots app menu.
- Search and click the widget to open it.
-
2. Add datasets
- In the Dataset tab, Click the + Dataset button.
-
Select a dataset with the data you need, then click Add Selected.
This action shows the fields in the dataset.
What else can you do in the Dataset section?
-
Search fields - Use keywords to search for the fields you need.
-
Order By - Sort all data from the added datasets based on the selected fields and sorting rules.
- Fill in the Field and Order By rules.
- Click Save.
- Fill in the Field and Order By rules.
-
Row Limit - Select an option to limit the rows of data for all added datasets.
-
Replace the dataset with another one you want.
- Hover over the name of the dataset.
- Click the ellipsis button, then select Select.
- Click your desired dataset and click Add Selected.Replace the dataset with one that matches the structure of the original dataset. For example, a dataset that only differs in field data values is essential to avoid error reports and widget malfunctions.
-
Rename, Clone, or Delete the dataset
- Hover over the name of the dataset.
- Click the ellipsis button, then select Rename/Clone/Delete.
* When you add a dataset with fields next to the triangle icon, it indicates that the field is associated with other datasets.
* The fields in the associated datasets can be dragged or added to the widget configuration area for settings.
* If you configure fields from the associated dataset in Query, Drill Through, or Options, the Widget Builder mode will stay in the New Widget Builder mode and cannot switch back to the original mode. You can switch back to the original mode only after you clear the fields from the associated dataset.
3. Set filters for the dataset
1. Data Scope
- When the dataset you are configuring has only one layer, this option is not editable. Skip this option and proceed to the next step.
- When the dataset you are configuring has multiple layers, select a layer you want to configure.
- How to check the number of layers in the dataset you are configuring?
- Search for the dataset you are setting up in Datasets and edit it.
- Click Layer to see how many layers there are.
- Search for the dataset you are setting up in Datasets and edit it.
- How to check the number of layers in the dataset you are configuring?
2. Query
- For Measure - Configure the fields to be calculated and the formula for calculating measures.
- Drag the required fields from the Dataset column to the Measure area, or click the + Drop Column Here or Click button to add a measure.
- Configure the following fields:
- Fields - Select a computation option from the Fields dropdown.
- Alias - Type an Alias for the measure.
-
Formula
- Summarize Type - When the Measure window opens, select a Summary Type.
- sum
- count
- avg
- max
- min
- string_agg
- Summarize Type - When the Measure window opens, select a Summary Type.
-
Format
- Format Type - Select a Format Type.
- Text
- Number
- Date
- Date Time
- Yes/No
- User
- Hyperlinks
- Display Type
- Decimals
- Format Type - Select a Format Type.
-
Custom SQL
- Calculate Measure
- Remove duplicate data - If you want to remove duplicate data when calculating data, please check this option.
- Click Save.
- For Dimension - Configure the fields and format you want to be displayed as a group.
- Drag the required fields from the Dataset column to the Dimension area, or click the + Drop Column Here or Click button to add a dimension.
- Configure the following fields:
- Fields - Select a grouping option from the Fields dropdown.
- Alias -Give an Alias for the dimension.
-
Format
- Format Type - Select a Format Type.
- Text
- Number
- Date
- Date Time
- Yes/No
- User
- Hyperlinks
- Display Type
- Format Type - Select a Format Type.
-
Custom SQL
- Calculate Measure
- Click Save.
- For Filter - Add conditions for filtering fields.
- Click the + Click to Add button.
- Select the field you want to filter.
- Set conditions for each field using the subsequent two dropdowns.
For a guide on each option on the list, refer to the article What Conditions are Available for Creating Widgets? - Select the logical operator AND or OR for the filter group.
- If you want to add multiple conditions or groups, click either + Condition or + Group to add.
-
-
Filter Inspector - Click Filter Inspector to check the filter settings by viewing the Filter Expression and Filter SQL.
- Click Save.
- For Order By - Sort the data of a specific layer in a certain dataset based on the selected fields and sorting rules.
- Click + Click to Add.
- Configure the following fields:
- Field - Select a parameter to sort the data.
- Order By
- Ascending
- Descending
- Click Save.
-
Row Limit - Select an option to limit the data rows for a specific layer in a certain dataset.
-
Remove duplicate data - If you want to remove duplicate data, select this option.
-
Materialized - Select an option from the Materialized dropdown menu to materialize data based on the actual conditions.
3. Drill Through
-
Column - Configure which fields are included in the widget.
- Drag the required fields from the Dataset column to the Column area, or click the + Drop Column Here or Click button to add a condition.
- Configure the following fields:
- Field
- Alias
- Format
- Format Type
- Text
- Number
- Date
- Date Time
- Yes/No
- User
- Hyperlinks
- Display Type
- Format Type
- Custom SQL
- Click Save.
-
Order By - Sort the data from drilling through a specific dataset based on the selected fields and sorting rules.
- Drag the required fields from the Dataset column to the Order By area, or click the + Drop Column Here or Click button to add a field.
- Fill in the following fields:
- Field
- Order By
- Ascending
- Descending
- Click Save.
4. Clear Query
When you want to clear all fields in Query and Drill Through at once, you can click the Clear Query button to avoid deleting them individually.
- Click Clear Query at the bottom of the page.
-
Click Continue.
4. Set the Options for the widget
4.1 Chart Type
Switch widget types by clicking the icon of your desired widget type.
The available types for switching in New Widget Builder mode are:
- Card Number
- Grid
- Column Chart
- Line Chart
- Heatmap
- Pie Chart
- Progress Tracker
-
Pivot Table
4.2 Design
Fill in the following fields:
- Chart Title - Provide a title for the data being presented.
- Dimension - Select the data for the x-axis (horizontal).
- Measure - Select the data for the y-axis (vertical) of the bar chart.
-
Multiple Measure
-
If not selected, the y-axis will have one measure.
-
If selected, multiple measures will appear on the y-axis, such as the left y-axis and the right Y-axis.
-
- Show as Cumulative - When checked, on the y-axis, the data in the back will automatically add the data in the front. For example, on the y-axis, the value of 'a' is 1, 'b' is 2, 'c' is 3. When checked, 'a' remains 1, 'b' becomes 3, 'c' becomes 6.
- Goal - Provide a preferred set goal, if necessary.
- Goal Color - Select an appropriate color for the set goal.
- Set Smooth - Select the Set Smooth box to apply smooth lines for the line chart.
- Dimension Group - Select a preferred dimension group from the dropdown list, if necessary.
- Trend Line - Select a preferred trendline from the dropdown list, if necessary.
- Dimension Name - Provide the name for x-axis of the line chart.
- Measure Name - Provide the name for the y-axis (vertical).
- yAxis Percentage - Selecting this option will display the percentage on the y-axis.
-
Right yAxis Corrdinate - If selected, it will display the coordinates on the right x-axis.
- Right yAxis Measure - Select the measure for the right y-axis.
- Right yAxis Label Name - Enter the label name for the right y-axis.
- Right yAxis Min - Enter the minimum value for the right y-axis.
- Right yAxis Max - Enter the maximum value for the right y-axis.
-
Right yAxis Percentage - Select to display the percentage on the right y-axis.
- xAxis NameRotate - Provide the preferred orientation for Dimension Name, if necessary.
- yAxis NameLocation - Select a preferred location for the Measure Name (Start, Center, or End) from the dropdown list, if necessary.
- yAxis NameGap - Provide a preferred number of gaps for Measure Name, if necessary.
-
yAxis Value - Set the maximum value, minimum value, and interval value for the yAxis.
- Connect Null Value - When checked, dimensions with null values will still be connected to form a line chart.
- Show Label - The default is to show the labels. Remove the selection for the Show Label checkbox if you prefer not to show these.
- Show Split Line - Select the checkbox for Split Line Show if you wish to show the split lines.
- Stacked Area Style - When checked, the Line Chart will be displayed in Stacked Line Chart style.
5. Conditional Formatting
If you want to change the text or background color when the fields meet specific conditions, or display as an icon, set a conditional formatting rule for your widget.
- Click the + Click to Add New Rule button.
-
Configure the following fields:
- Name
- Field
- Value
-
Color Cell - Select the format to be applied once conditions are satisfied. You can apply color to a cell or row.
- Background Color
- Text Color
- Icon
-
Color Entire Row
- Background Color
-
Text Color
-
Click Save.
6. Save your settings
-
Click Save to open the Save popup.
-
Fill in the following fields:
- Name
- Description
- More Info
- Tag
-
Role
- Click Save.
New widgets are at the bottom of dashboards, scorecards, and reports. When you save a new widget, the screen will automatically scroll to show where the new widget is.
You can edit the dashboard design by modifying the widget's placement in the dashboard.
What other actions are available from the widget's screen in the new Widget Builder?
Switching to the original Widget Builder
If you want to switch back to the original Widget Builder page, click to open the Unsaved Changes pop-up window.
- If you do not want to save the settings in the New Widget Builder, click Leave without Saving.
- If you want to save the settings in the New Widget Builder, click Save Changes.
Creating a bot from the widget
- Click More Options , and then select Create Bot.
- For more details on creating a bot, see How to Create a Bot from a Widget in New Widget Builder mode.
Creating a filter for the widget
The filter is for secondary filtering of the data filtered in the Dataset.
- Click More Options , and then select Filter.
- Select a field you want to filter.
- Set a condition for the field using the subsequent two dropdowns. For descriptions of each option, refer to What Conditions are Available for Creating Widgets?
- If you want to add multiple filter conditions,
- Click the Add icon and choose either Add Condition or Add Group.
- Add Condition - Add a filter condition.
-
Add Group - Add a condition group.
- Repeat steps 2 and 3.
- Click the Add icon and choose either Add Condition or Add Group.
- Select the logical operator AND or OR for the conditions or filter groups.
- AND - Conditions within a group or groups are connected by an AND relationship, which requires that all conditions or groups must be fulfilled.
- OR - Conditions within a group or groups are connected by an OR relationship, which means that only one of the conditions or groups needs to be fulfilled.
- Click ok to keep your settings.
Cloning the widget
- Click More Options , and then select Clone.
- Fill in the following fields:
- Name
- Role
- Description
- Click Confirm.
Deleting the widget
- Click More Options , and then select Delete.
- Click Confirm.
Sharing the widget
- Click button to copy the url of the widget.
- When Copy Success appears, the copy is successful.
You can share it with others to view the widget.