Page History

...

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.
   Image RemovedImage Added
   
4. When the Widget Builder window opens, provide the following: 
   • Name - Give the widget slicer a name. 
   • Description - Provide a short description. 
   • Role - Select which role/s should be able to access the slicer. Either User or Admin or both.
     Image Removed
     Image Added
     
     
5. Click the Apply button.
6. Check the dataset of the widget you wish to create the slicer and select accordingly.
   Image Removed
7. Next, go to Dataset and click the + button. 
   Image Added
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. . It should be in line with the dataset of the widget/s that would be linked to the slicer.
   • 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 dimensionsvalues for the Filter, Measure, and/or Dimension, as well as on Order By, if they are necessary for the data that you need.
     
     Important: Make sure to tick the checkbox for Remove Duplicate Data. Also, most common is that you will only be needing to add values on the Filter and Order By. 
     
     
10. Click the Save button . Click Apply. This will show a preview of the slicer that you createdthen the Apply.
11. Next, go to Config and provide data for the following fields: 
    • Text - Set Input the alias Alias of the column name in the text fieldyou want to use. 
    • Value - Set the alias of the column name Input the same Alias you have entered in the text field. 
    • QueryParams - Set Input the alias same Alias of the column name in from the text field. 
    • Watermarks - Set the alias of the column name in the text field. ExInput the words/phrase you want to appear on the slicer before value is chosen. E.g. Select a Board. 
    • Filter Label - Input the filterslicer's label. . E.g. Board or Board Name.
    • Select - Select whether to include ALL or Only First. This is in line with when you tick the Multiple Mode check box.
      When you select ALL, the default selected value of the slicer would be all the available values for it, thus, the widget/s linked to it will show all the data for those values. But when it is Only First, the default selected value would be the first available value of the slicer.   
      
12. Click Apply. . This will show a preview of the slicer that you created.