[]
        
(Showing Draft Content)

Slicers

Slicers are visual filters that dynamically filter the data at run-time and make the dashboard more effective and interactive. The scope of influence that slicers have on the dashboard includes the scenarios that are on the same page and on different pages of the dashboard as well, that use the same dataset. It allows the users to use the slicers with multiple-page dashboards.


The following table explains the different types of built-in slicers available in Wyn Enterprise. You can also create a custom slicer based on your business requirements.

Slicer

Description

Label Slicer

Label Slicer Icon

It allows you to apply a filter to a data attribute in the dataset.

Multi-dimensional Slicer

Multi-dimensional Slicer

It enables you to add a filter to multiple data attributes in a single slicer. The chosen data attributes are displayed in a hierarchical order within a list. You can build a hierarchy tree using the following options in the Data Binding Panel - Multi-Dimensions, Parent-Child, and Hierarchy.

Multi-dimensional Dropdown Slicer

Multi-dimensional Dropdown Slicer

It enables you to add a filter to multiple data attributes in a single slicer. The chosen data attributes are displayed in a hierarchical order within a dropdown. You can build a hierarchy tree using the following options in the Data Binding Panel - Multi-Dimensions, Parent-Child, and Hierarchy.

Data Range Slicer

Data Range Slicer

It allows you to apply a filter to any measure in the dataset and displays the data that meets the specified value range.

Date Range Slicer

Date Range Slicer

It allows you to apply a time-based filter to any date attribute in the dataset or model with various granularities of 'year', 'year-quarter', 'year-month', 'date', and 'date-time'. It also provides support for different precision filters, which are controlled through the Display Mode property of the slicer. Date and date range are the two types of display modes. In date display mode, you can filter the data based on a single-valued date. While in date range display mode, you can filter the data based on multi-valued dates, such as start time and end time. There are two more properties Allow Switch Display Mode and Allow Switch Display Mode. For details refer Switch Date Mode and Display Mode. You can also set a default value(s) for the slicer in both modes. For details about setting the default values, refer to the section Set Relative Date.

Relative Date Slicer

Relative Date Slicer

It allows you to apply a filter to the dashboard data depending on a relative date and the chosen date attribute. For details about setting the default values, refer to the section Set Relative Date.

Add a Slicer

  1. From the Slicers node, drag-drop the Label Slicer on the design area.

  2. On the Data Binding area, choose an appropriate dataset and then select an attribute for the Columns field. For example, in the following image, we selected the 'Customer Satisfaction' attribute.


    Binding Dataset to Slicer


    Or,


    To bind the slicer to custom data, set the Data Source property in the Inspector panel to Custom Values, and then add customized values based on your needs. By, default, this property is set to From Query.


    Bind to Custom Data

  3. Select any data attribute for the Columns field. For example, in the following image, we selected the 'Customer Satisfaction' attribute.


    Binding Dataset to Slicer

  4. Click the Edit button in the upper-right corner of the slicer. You will get the following options: select parameter, no sort, search, and share scenario.


    Edit a slicer

  5. If you choose any data value in the edit mode of the slicer, the value is set as its default value. To clear the selected value and restore the slicer to its initial state, use the Clear Selection editing option which is now available. In the following image, we selected 'Average' as the default value for the slicer.


    Setting Default Value in Slicer

  6. Apply filter or sort operation on the data values using the Action Bar corresponding to the selected slicer. For example, the data values for the 'Customer Satisfaction' field are manually sorted in the below slicer.


    Setting Default Value in Slicer

    Note: Slicers like data range, date range, and relative date do not support the filter and sort operations on their data values.

  7. In the Inspector tab of the slicer, you can define various properties related to its layout, interaction, data, title, and so on. For example, if you want to set or modify the text alignment in the slicer, use the Alignment property as shown.


    Setting properties for slicer

  8. Preview the dashboard.


    In the following dashboard, data is filtered based on the 'Customer Satisfaction' values selected in the slicer.


    Slicer Example

Slicer Filter Scope

This section explains the scope of influence that slicers have on the dashboard scenarios based on the filters. You can find Slicer Filter Scope on the Inspector tab.


Slicer Filter Scope


Following table explains the different types of Filter Scopes available.

Filter Scope

Description

Auto

This is the default value. It means: If you put the slicer on a container, the scope of filtering can be limited to the container and the data will be filtered in the container based on slicer filter criteria. If you put the slicer on the page, the filter scope is page, and the data will be filtered on the same page as per the slicer filter criteria.

Page

If this option is selected, then the filter scope is page, and the data will be filtered on the same page as per the slicer filter criteria.

Dashboard

If this option is selected, then you can use the cross-page filtering ability of the slicer to work with multi-page dashboards. Example: You have multiple pages in a dashboard. On the first page of the dashboard, you have a slicer and on the second page you have a chart, and you select the Filter Scope as Dashboard. This will filter out the data on the second page as well, based on the slicer filter value selected on the first page.

Note: Once the scope of the slicer is set to Dashboard, it will take effect on all the charts/slicers bound to the same datasets and cannot be canceled for a certain chart/slicer unless the scope of the slicer is set to Auto or Page.

Supported Slicer Types

  • Label Slicer

  • Multi-dimensional Slicer

  • Multi-dimensional Dropdown Slicer

  • Data Range Slicer

  • Date Range Slicer

  • Relative Dates Slicer

Slicer filter scope when putting the slicer on the container

The table below describes the 'Slicer filter scope' when a slicer is put on the container.

Container Filter Scope

Slicer Filter Scope

Container

Page

Auto

Container

Page

Page

Page

Page

Dashboard

Dashboard

Dashboard