Explo
Search…
Getting Started
Database Setup
Creating Dashboards
Embedding Documentation
API Documentation
Security
Troubleshooting
Date Range Picker
Date range pickers allows your customers to filter the dashboard by a date range.
What it does
This component allows you to create a date range picker input which your users can use to filter data.
When the element is added to the dashboard, it looks like:
Configuration
Date range picker configuration
Basic Configuration
Configuration Option
Description
Label
This text is the label given to the dropdown select on the dashboard. The label is placed above the dropdown. This field can be empty.
Default Range
This allows you to set the selected range that the component will default to
Enable user dropdown
(Default: False) This enables the date range element to have a dropdown attached to it that allows your users to select pre-defined ranges rather than needing to use the date picker to select the range.
Variable Usage
To access the elements in the SQL editor, use the following syntax:
1
--to reference the first date
2
{{date_range_picker.startDate}}
3
​
4
--to reference the second date
5
{{date_range_picker.endDate}}
6
​
7
​
8
--example
9
WHERE 1=1 [[AND date_field >= {{date_range_picker.startDate}}]]
10
[[AND date_field <= {{date_range_picker.endDate}}]]
Copied!
​
Last modified 5mo ago
Copy link