The FPT Data Suite system supports three main groups of slicers, each designed for different types of data filtering:
A tool that allows users to filter data based on a hierarchical structure. It includes:
Tree Slicer (Fixed Dataset)
Tree Slicer (Infinite Dataset).
A slider-based filter that lets users filter data within a specific range of numeric values.
A time-based slider that enables filtering of data over a specific date or time range. It includes:
Date Range – for fixed start and end dates.
Date Range Relative – for dynamic periods (e.g., "last 7 days", "next 30 days").
The Tree Slicer (Infinite Dataset) is an advanced filtering component that enables users to select one or more values from a list to filter data across the entire report page. It is especially useful for dynamic or large datasets and supports use cases such as:
Browsing and selecting values in a tree structure or flat list.
Filtering data across the page by one or more selected values.
Supporting filters by time, category, region, and more.
Allowing multi-selection of values.
Enabling quick search within long lists.
Tree Slicers (Infinite Dataset) can be placed in various areas within the Report to optimize filtering and enhance user experience:
Page: Displayed directly on the Report Page for quick access to filter controls without navigating away.
Filter: Placed alongside other global filters for multi-chart or multi-page filtering.
Filter Panel: Displayed in the collapsible filter panel to allow real-time filter interaction without affecting the page layout.
Configuration is done via the Build tab on the right-side panel of the interface. Below are the main configuration options:
Title: Sets the display name of the slicer. Appears above the slicer to help users understand its filtering purpose.
Dimensions
The most important configuration area.
Drag and drop one or more fields from the Data Sample into this section.
When multiple dimensions are added, the slicer displays a hierarchical tree view.
Search Configuration: Controls the behavior of the search function within the slicer. Supported modes:
Text: Searches for exact matches.
Syntax: Supports advanced expressions like wildcards or regular expressions (regex) for flexible filtering.
Limit: Defines the number of values displayed initially. Additional values are loaded when the user clicks "Load more" or uses the search function.
Copy/Paste Confirmation: Enables or disables the ability to show the selection/search box, allowing:
Copying values into the slicer from external sources.
Exporting selected items from the slicer.
Dimension Labels: Adds secondary labels (e.g., names, descriptions) alongside the main dimension (e.g., code or ID). Useful when primary dimension values are not human-readable.
Show on List with Dimension; Toggle whether to display the Dimension Label alongside the main dimension in the slicer.
Keep All Filter: Determine whether the slicer should respond to other filters in the report:
Off: The slicer ignores all other filters.
On: The slicer updates dynamically based on other filters (e.g., from charts or other slicers).
Sort: Controls how values are sorted within the slicer. Configure sorting by selecting a dimension and choosing:
Ascending
Descending
You can create a Slicer to filter data visually by following these steps: