Skip to main content

What are the Slicer Configuration Fields for Creating Slicers?

Updated

This article describes each of the Slicer configuration fields available when creating slicers. To read about the detailed steps in creating slicers, see How to Create Slicers in Widgets.

Date Range

Field  Description
Select Default Date Range

This field sets the default time range displayed in the slicer. Selecting Last 7 Days displays the data for the past 7 days.

Below are the available options for Default Date Range: 

  • Last 7 Days 
  • Last 30 Days 
  • Last 90 Days 
  • Last 120 Days 
  • Last 7 Business Days 
  • Last 30 Business Days 
  • Last 90 Business Days 
  • Last 120 Business Days 
Date From QueryParams

The value of Date To QueryParams is used to connect the slicer to the widget.

If there is a data range type slicer in a widget, you can input dateFrom for it.

If there are multiple data range type slicers in a widget, you need to differentiate these fields. For example, you can input dateFrom1, dateFrom2.
Date To QueryParams 

The value of Date To QueryParams is used to connect the slicer to the widget.

If there is a data range type slicer in a widget, you can input dateTo for it.

If there are multiple data range type slicers in a widget, you need to differentiate these fields. For example, you can input dateTo1,dateTo2.
Filter Label Input the slicer's label or name. Example: Days.
 




Dropdown List 

Field Description
Text

Input the Alias from a field selected in the Data Source. The values of the Text will be visible in the slicer options.
Value

Input the Alias from the field selected in the Data Source. This value will be used to look up and filter connected widgets.

Text and Value usually refer to the same data field. However, there are optional cases where you need to use different values for each field. For example, in a widget, only the employee ID is available as a data field. You can create a slicer where Text = Employee Name and Value = Employee ID. This way, you can use the slicer to filter the widget while easily understanding the slicer options.
QueryParams

The QueryParams field is used to connect the slicer to the widget. Any text or value can be input here.

Using "Company" as the value in the QueryParams field also has an additional function of sharing company-filtered data in the Schedule Report of Dashboards.
Placeholder Input the text to show on the slicer field before a value is chosen. Example: Select Company.
Filter Label

Input the slicer's label or name. Example: Companies.
Default Value
  • All - Selecting ALL sets the default slicer value to all the available values thus, the widget/s linked to this will show all the data for the value.
  • Only First - Selecting Only First sets the default slicer value to the first available value for the slicer. 
Multiple mode A checkmark on this checkbox allows the user to select multiple values in the slicer.
Strict mode
  • If strict mode is enabled, nothing will be displayed if the slicer options are cleared.
  • If strict mode is not enabled, all data will be displayed if the slicer options are cleared.

By default, this option is not selected.
 




Input 

Field Description
QueryParams

The QueryParams field used to connect the slicer to the widget. Input the Alias from a field selected in the Data Source.
Watermark Input the text to show on the slicer field before a value is chosen. Example: Search.
Filter Label Input the slicer's label. Example: Summary.
 




Cascader List 

Field Description
Associated fields

Select an Alias from a field selected in the Data Source.
Text Input the Alias from a field selected in the Data Source. The values of the Text will be visible in the slicer options.
Value

Input the Alias from the field selected in the Data Source. This value will be used to look up and filter connected widgets.

Text and Value usually refer to the same data field. However, there are optional cases where you need to use different values for each field. For example, in a widget, only the employee ID is available as a data field. You can create a slicer where Text = Employee Name and Value = Employee ID. This way, you can use the slicer to filter the widget while easily understanding the options that appear in the slicer.
QueryParams

The QueryParams field is used to connect the slicer to the widget. Any text or value can be input here.

Using "Company" as the value in the QueryParams field also has an additional function of sharing company-filtered data in the Schedule Report of Dashboards.
Water Mark Input the text to show on the slicer field before a value is chosen. Example: Select. 
Filter Label Input the slicer's label. Example: Company.
 




User Dropdown List 

Field Description
Watermark Input the text to show on the slicer field before a value is chosen. Example: Select a User. 
Filter Placeholder Input the text to show on the slicer field when selecting a value. Example: Search.
 


 

Related articles