How to Create Slicers on Widgets

Slicers give users control over large data by applying filters that would show or hide data. When a slicer on the MSPbots widgets is selected, filters are applied and users view only the data that is useful for their task or goal. This article shows the procedure for setting up slicers that will allow clients to easily refine data for themselves. 

Before you start, make sure that you are logged in to MSPbots with administrator permissions.

Follow these steps when creating slicers 

1. On the MSPbots app's menu, go to Settings > Slicer.
2. Click the New Slicer button on the Slicer tab. This step opens the New Widget window. 
3. Next, select the Dropdown List slicer type on the New Slicer window. This action opens the Widget Builder window.
4. When the Widget Builder window opens, provide the following: 
   • Name - Give the widget a name. 
   • Description - Provide a short description. 
   • Role - Select User or Admin.
     
5. Click the Apply button.
6. Check the dataset of the widget you wish to create the slicer and select accordingly.
   
7. Next, go to Dataset and click the + button. 
8. Select New Layer on the window that appears. This step opens the Dataset window.
   
9. Do the following on the Dataset window: 
   • Select a dataset to use. 
   • Add columns by selecting an option from the Column Name dropdown list and assigning an Alias and Business Type for each. Click the + icon to add more rows.
   • Add filters, measures, and dimensions.
     
     Important: Make sure to tick the Remove Duplicate Data checkbox.
     
     
10. Click the Save button.
11. Click Apply. This will show a preview of the slicer that you created.
12. Next, go to Config and provide data for the following fields: 
    • Text - Set the alias of the column name in the text field. 
    • Value - Set the alias of the column name in the text field. 
    • QueryParams - Set the alias of the column name in the text field. 
    • Watermarks - Set the alias of the column name in the text field. Ex. Select a Board. 
    • Filter Label - Input the filter's label. 
    • Select - Select to include ALL or Only First.   
      
13. Click Apply.