Filter/ Data Control

Date range filter

Create a date range filter

Date range filter allows you to filter your report data based on a date and time range.

  1. Select Date range filter to begin adding this type of filter to the canvas

  2. Drag select an area on the canvas to place the filter on the dashboard

  1. In the right panel, fill out the following fields in Filter tab to customize the functionality of the filter

  2. Label: enter the name you want to name the filter

  3. Key: select the parameters you’d like to use for the filter

  4. Default value: select the from and to date range for the date filter

  5. Show time select: select when you’d like to show the filter for time in addition to the date range

  6. Hide when exist on URL: You can show or hide filter when you share via URL

Style a date range filter

  1. Search: Search option you want to appear by text in the box

  2. Label font size: Choose the size for label

  3. Data font size: Choose the size for Data

  4. Line break between and input: Allow to break a line between label and data a. Tick box to enable b. Untick box to disable

  1. 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:

  1. Font: Choose font for your filter

  2. Font size: Choose size for your filter

  3. Format: Bold, Italic

  4. Text color: Color the filter text

  5. Fill color: Fill color to the filter box

  6. Vertical alignment: align the filter to top, center, bottom

  7. 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

  1. Box alignment:

Align the content inside the filter box to the side you want to set

  1. Box shadow: Tick box to enable box shadow Untick box to unable box shadow

Text filter

Filter for matching text.

Create a text filter

  1. Click on the "filter" to show the list of available filters

  1. Select “Text” to begin adding this type of filter to the report canvas

  2. Drag select an area on the canvas to place the filter on the report

  3. 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

Style a text filter

To style the look of the filter, click on Style tab

  1. Search: Search option you want to appear by text in the box

  2. Label font size: Choose the size for label

  3. Data font size: Choose the size for Data

  4. Line break between and input: Allow to break a line between label and data

  • Tick box to enable

  • Untick box to disable

  1. 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:

  1. Font: Choose font for your filter

  2. Font size: Choose size for your filter

  3. Format: Bold, Italic

  4. Text color: Color the filter text

  5. Fill color: Fill color to the filter box

  6. Vertical alignment: align the filter to top, center, bottom

  7. Border:

  8. Weight: choose weight for the line of filter box

  9. Radius: Choose to round filter box

  10. Style: Style the line of filter box

  11. Color: Color the line of filter box

  1. Box alignment

Align the content inside the filter box to the side you want to set

  1. Box shadow: Tick box to enable box shadow Untick box to unable box shadow

Absolute time range

Create an absolute time range

Use this filter if you would like to use something similar to “Date range” filter but with advanced customization options.

  1. Select Absolute time range to begin adding this type of filter to the report canvas

  2. Drag select an area on the canvas to place the filter on the report

  3. 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”

Style an absolute time range filter

To style the look of the filter, click on “Style” tab

  1. Search: Search option you want to appear by text in the box

  2. Label font size: Choose the size for label

  3. Data font size: Choose the size for Data

  4. Line break between and input: Allow to break a line between label and data Tick box to enable Untick box to disable

  5. 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:

  1. Font: Choose font for your filter

  2. Font size: Choose size for your filter

  3. Format: Bold, Italic

  4. Text color: Color the filter text

  5. Fill color: Fill color to the filter box

  6. Vertical alignment: align the filter to top, center, bottom

  7. Border:

  8. Weight: choose weight for the line of filter box

  9. Radius: Choose to round filter box

  10. Style: Style the line of filter box

  11. Color: Color the line of filter box

  1. Box alignment

Align the content inside the filter box to the side you want to set

  1. Box shadow: Tick box to enable box shadow Untick box to unable box shadow

PreviousGraph Max/ Min/ AverageNextCreate an email delivery Schedule

Last updated