v8.0

Composite Slicer

Composite Slicers provide the flexibility to apply filter criteria by using the logical And/Or relationship between these filter conditions when previewing the dashboard. Composite filters enable more granular data analysis when previewing dashboards, allowing you to filter the data dynamically without setting up all filter conditions at design time.

Example: In this example, a series of filter criteria are added through a combination of filters when previewing the dashboard. The dashboard below shows the sum of units in stock by product name with the following filter conditions applied while previewing the dashboard:

ProductName In Aniseed Syrup, Chai, Chang
AND
SupplierID = 1

There is an And relationship between these filter conditions, and all the data that meet the above conditions will be filtered out as shown below in the image.

CompositeFilterScenario

Steps to add a Composite Slicer

You can add the composite slicer in the designer, but they are only available when previewing.

Follow the steps given below to add a composite slicer.

From the Slicers node, drag-drop the Composite Slicer on the design area.
On the data binding panel, select the dataset or data model for the corresponding fields you want to use at the preview for filtering. To add datasets or models to the dashboard scenario use the + Add button.

Note: Composite filter and Scenario on which you want to apply the filter should have the same dataset/data model binding.
Drag and drop a Column Chart on the dashboard designer. From the data binding panel, choose an appropriate dataset and then select an attribute for the Values and Axis (Category) fields. For example, in the following image, we have selected the UnitsInStock for the Values field and ProductName for Axis(Category) field.
Preview the dashboard. The column chart will display the Sum of UnitsIn Stock for all the products. On the composite slicer, you will see the options to add the filter conditions.
Click the Add Condition (And) or Add Condition (Or) button to add filters. Select a field from the Choose Filed dropdown, select a condition from the condition dropdown, and select or enter the value in the third input box. Click Submit to apply.
Add multiple filter criteria by clicking the Add Condition (And) or Add Condition (Or) buttons. You can also switch the conditions to And or Or using the relation dropdown.
To add a condition on a particular item, hover on the item, click the + button, and select a condition (Add Condition (And) or Add Condition (Or)).
To delete an item, hover on the item and click the delete icon.

Based on the field type, the available conditions vary as described below.

Field Type	Options Available
String	Contains, Does Not Contain, Start With, Does Not Start With, End With, Does Not End With, Equal, Not Equal, In, Not In
Numeric Value	Less Than, Less Than or Equal To, Greater Than, Greater Than or Equal To, Equal, Not Equal, In, Not In
Date/DateTime	Earlier Than, Earlier Than or Equal, Later Than, Later Than or Equal, In, Not In

Customize Appearance

You can customize the appearance of the Composite Slicer scenario using the Inspector Panel properties on the right side of the dashboard designer window, listed and described in the following tables.

FILTER CONTENT STYLE

Option	Description
Font	Set the family, size, color, thickness, and style of the fonts of the filter conditions on the composite slicer using this property.
Background Color	Set the background color of the filter content.
Border Radius	Set the border-radius.
Relation Line Color	Set the color of the relation line.

CompositeFilter-filtercontentStyle

OPERATOR BUTTON STYLE

Option	Description
Font	Set the family, size, color, thickness, and style of the fonts of the operator button (Add Filter, Submit) of the composite slicer using this property.
Background Color	To set the background color of the operator buttons (Add Filter, Submit) of the composite slicer, select a color from the color palette.
Border Color	To set the border color of the operator buttons (Add Filter, Submit) of the composite slicer, select a color from the color palette.
Border Width	Set the width of the border of the operator buttons (Add Filter, Submit) of the composite slicer, using this property.
Border Radius	Set a border radius of the operator buttons (Add Filter, Submit) of the composite slicer, using this property.

OPerator button style

ANIMATION

Property	Description
Entrance Animation	Select an option from the dropdown to set the animation style of the appearance of the composite slicer scenario. After selecting an option (SlideInDown, SlideInLeft, SlideInRight, SlideInUp, BackInDown, BackInLeft, BackInRight, BackInUp,FadeIn, FadeInDown, FadeInLeft, FadeInRight, FadeInUp,BounceIn, BounceInUp, BounceInDown, BounceInLeft, BounceInRight,LightSpeedInLeft, LightSpeedInRight, RotateIn, RotateInDownLeft, RotateInDownRight, RotateInUpLeft, RotateInUpRight, ZoomIn,ZoomInDown, ZoomInLeft, ZoomInRight, or ZoomInUp ) from the dropdown, set the delay and duration of the animation using the Delay(s) and Duration(s) properties respectively.

Property

Description

Entrance Animation

Select an option from the dropdown to set the animation style of the appearance of the composite slicer scenario. After selecting an option (SlideInDown, SlideInLeft, SlideInRight, SlideInUp, BackInDown, BackInLeft, BackInRight, BackInUp,FadeIn, FadeInDown, FadeInLeft, FadeInRight, FadeInUp,BounceIn, BounceInUp, BounceInDown, BounceInLeft, BounceInRight,LightSpeedInLeft, LightSpeedInRight, RotateIn, RotateInDownLeft, RotateInDownRight, RotateInUpLeft, RotateInUpRight, ZoomIn,ZoomInDown, ZoomInLeft, ZoomInRight, or ZoomInUp ) from the dropdown, set the delay and duration of the animation using the Delay(s) and Duration(s) properties respectively.

Animation

Interaction

Property	Description
Scenario Name	Add a name to the composite slicer scenario using this property.
Visible Menu Items	Select the filtering and sorting options you wish to display on the composite slicer scenario from the dropdown.

Interaction

TITLE

Property	Description
Show Title	To hide the title of the composite slicer scenario set this property to False. By default, this property is set as True.
Title	Add or edit the title of the composite slicer scenario using this property.
Alignment	Select the Left, Center, or Right alignment of the title.
Title Font Setting	Set the font family, size, color, weight, and style of the title using the Title Font Setting options.
Padding	To create space around the title of the composite slicer scenario use the Padding property. It supports Padding Left, Padding Top, Padding Right, and Padding Bottom. Their values can be different.

Title

SPECIAL DATA

Property	Description
Show Null As	Set the content to display in place of null data in the composite slicer scenario using this property.
Show Blank As	Set the content to display in place of blank data in the composite slicer scenario using this property.

Special Data

Layout

Property	Description
X Position	Set the horizontal position of the composite slicer scenario using this property.
Y Position	Set the vertical position of the composite slicer scenario using this property.
Width	Set the width of the composite slicer scenario using this property.
Height	Set the height of the composite slicer scenario using this property.

Layout

Note: Minimum Height and Width supported is 8X8“.

Appearance

Property	Description
Style Template	Select a template from the dropdown to apply a style to the composite slicer scenario.
Background Color	Set a background color of the composite slicer scenario using this property.
Padding	To create space around the composite slicer scenario, set a padding value.
Margin	Set the margin value for the composite slicer scenario using this property.
Visibility	To hide the composite slicer from the dashboard scenario, set this property to False. By default, the Visibility property is set as True.
Background Image	Add an embedded, shared, or external image as a background image to the composite slicer scenario.
Border	Set the border type, border color, and thickness using this property.
Shadow	Create a shadow of the composite slicer scenario by setting the Shadow Type, Shadow Color, and thickness.

Appearance