Filter/ Data Control
Last updated
Last updated
Date range filter allows you to filter your report data based on a date and time range.
Click on the icon on the left toolbar to show the list of available filters
Select Date range filter to begin adding this type of filter to the canvas
Drag select an area on the canvas to place the filter on the dashboard
In the right panel, fill out the following fields in Filter tab to customize the functionality of the filter
Label: enter the name you want to name the filter
Key: select the parameters you’d like to use for the filter
Default value: select the from and to date range for the date filter
Show time select: select when you’d like to show the filter for time in addition to the date range
Hide when exist on URL: You can show or hide filter when you share via URL
Search: Search option you want to appear by text in the box
Label font size: Choose the size for label
Data font size: Choose the size for Data
Line break between and input: Allow to break a line between label and data a. Tick box to enable b. Untick box to disable
Show description: Note on the box, then you can see the question mark on the top right corner of filter
Like style your chart, you can style your filter box by looking at the bottom toolbar below
From the left to the right:
Font: Choose font for your filter
Font size: Choose size for your filter
Format: Bold, Italic
Text color: Color the filter text
Fill color: Fill color to the filter box
Vertical alignment: align the filter to top, center, bottom
Border:
Weight: choose weight for the line of filter box
Radius: Choose to round filter box
Style: Style the line of filter box
Color: Color the line of filter box
Box alignment:
Align the content inside the filter box to the side you want to set
Box shadow: Tick box to enable box shadow Untick box to unable box shadow
Filter for matching text.
Click on the "filter" to show the list of available filters
Select “Text” to begin adding this type of filter to the report canvas
Drag select an area on the canvas to place the filter on the report
In the right panel, fill out the following fields in “Filter” tab to customize the functionality of the filter
Label: enter the name you want to name the filter
Key: select the parameters you’d like to use for the filter c. Hide when exist on URL: When enabled, this filter will be hidden when its param exists on the URL.
Ex: filter is using params @my_param
Case 1: url is https://app.dataflake.co/s/xxx/?my_param=value => Filter is hidden
Case 2: url is https://app.dataflake.co/s/xxx=> Filter is visible
Case 3: url is https://app.dataflake.co/s/xxx/?not_my_param=value => Filter is visible
Select input: if enabled, set settings for the following
Multiple select: enabled if you want to allow viewers to apply multiple filter options at once Default all options: set default to all when using options from a datasource
Enabled Disabled: will need to set “Default value” if disabled
Condition: set the condition to be check against the value input
Options source
Manual: input filter options by hand
Click “Add an option” to manually add an option
All added options are listed under “Options”
Data source: pull filter options from data through queries
Choose database connection you would like to pull options from
Choose a query from an already existing query
Click "+" icon to add a new query
To style the look of the filter, click on Style tab
Search: Search option you want to appear by text in the box
Label font size: Choose the size for label
Data font size: Choose the size for Data
Line break between and input: Allow to break a line between label and data
Tick box to enable
Untick box to disable
Show description: Note on the box, then you can see the question mark on the top right corner of filter
Like style your chart, you can style your filter box by looking at the bottom toolbar below:
From the left to the right:
Font: Choose font for your filter
Font size: Choose size for your filter
Format: Bold, Italic
Text color: Color the filter text
Fill color: Fill color to the filter box
Vertical alignment: align the filter to top, center, bottom
Border:
Weight: choose weight for the line of filter box
Radius: Choose to round filter box
Style: Style the line of filter box
Color: Color the line of filter box
Box alignment
Align the content inside the filter box to the side you want to set
Box shadow: Tick box to enable box shadow Untick box to unable box shadow
Use this filter if you would like to use something similar to “Date range” filter but with advanced customization options.
Select Absolute time range to begin adding this type of filter to the report canvas
Drag select an area on the canvas to place the filter on the report
In the right panel, fill out the following fields in Filter tab to customize the functionality of the filter
Label: enter the name you want to name the filter
Key: select the parameters you’d like to use for the filter
Default value
a. Absolute time range: enter the custom days from now () for from and to you would like to set
b. Around fixed value: the day you would like to use as “now()”
c.Relative time range: select a relative time range from now, Ex: when select “last 5 minutes” query params will have values “now()” and “now() - 5 minutes”
To style the look of the filter, click on “Style” tab
Search: Search option you want to appear by text in the box
Label font size: Choose the size for label
Data font size: Choose the size for Data
Line break between and input: Allow to break a line between label and data Tick box to enable Untick box to disable
Description note: Note on the box, then you can see the question mark on the top right corner of filter
Like style your chart, you can style your filter box by looking at the bottom toolbar below:
From the left to the right:
Font: Choose font for your filter
Font size: Choose size for your filter
Format: Bold, Italic
Text color: Color the filter text
Fill color: Fill color to the filter box
Vertical alignment: align the filter to top, center, bottom
Border:
Weight: choose weight for the line of filter box
Radius: Choose to round filter box
Style: Style the line of filter box
Color: Color the line of filter box
Box alignment
Align the content inside the filter box to the side you want to set
Box shadow: Tick box to enable box shadow Untick box to unable box shadow
Click on theto show the list of available filters
