Prerequisites
- Make sure that dashboards with widgets are available.
- Set up a slicer or identify a template slicer to use.
To add a slicer on the dashboard
- Navigate to Dashboards on the MSPbots app.
- Search for the dashboard that needs updating.
- Click the dashboard to open. Let's use the dashboard below as an example. We will add a company slicer to filter the device count for each company.
- Add a slicer. Start by clicking the Design button on the upper right section of the screen.
-
Next, click Add Widget.
- On the Add Widget window, click Slicer List then search for the slicer you want to use. You can search from either the My Slicers or Slicers Template tab.
Refer to How to Create Slicers in Widgets for instructions on setting up slicers.
-
Select your chosen slicer and click Add.
The slicer is now added to your dashboard.To make the slicer work successfully with the other widgets on the dashboard, you need to update all the widgets and add the slicer as one of its filters in the setup. Please be guided by the steps below. -
To add the slicer to the widget.
- Click the ellipsis ... icon on the widget and select Edit.
- Click the Dataset icon, then click the ellipsis ... and select Edit.
- Go to the Filter section. Add a new condition by clicking the add + icon and selecting + Add Condition.
- Next, click the AND tab and do the following:
- Select the column name for the slicer. For example, company_name.
- Select IN as the query string.
- (Optional) Fill in the value field of the filter.
- Select the Slicer checkbox.
- Click the blank box to the right of Slicer.
-
Enter and select the slicer you added in the dashboard. For example, ConnectWise Automate Client Name.
If the desired Slicer filter criteria are unavailable,
1, click Advance to customize advanced filtering conditions.
2, Enter the advanced conditions in the blank box.
- (Optional) Check Ignore Filter.
- When the Ignore Filter option is checked, the value field will be grayed out. Only the column field and query string need to be filled in.
- Only the slicer will be effective.
Do not select the OR operator for slicers.
-
Click the Save button to save the changes.
-
- Click the ellipsis ... icon on the widget and select Edit.
- Repeat step 8 for all the widgets on the dashboard to apply the slicer (e.g., company_name) and ensure it works on all widgets.