Comment on page
Date Parameter
Dates parameters are replaced by date values in your queries. They are always used in pairs, defining the start and the end of a period of time.
When creating a dates parameter, there are a few settings to be defined:
Define the dates that will be available for selection in the control UI. The calendar will be limited to the dates defined in this setting.
Defining selectable date range values
- Display name: The name that will appear in the control UI.
- SQL name(s): The name to be used in the SQL query to be replaced by the starting and ending date of the selected period.
Once the parameter has been created, it should be added manually (using its SQL names) to one or more of your SQL Query data sources, like:
SELECT * FROM carto-demo-data.demo_tables.spain_earthquakes
WHERE time >= {{date_from}} AND time <= {{date_to}}
After adding the parameter to your SQL query data sources, the control UI will appear in the right-side panel, allowing to define the min and max pair of date values:
Control UI for a Date Parameter
Last modified 4mo ago