- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-24-2024 06:53 AM - edited 10-24-2024 07:00 AM
I added a filter with the :name_parameter to the dashboard and it works fine.
But if I add a date range picker for the date axis it doesn't do any effect (standalone, without the other filter enabled, it is working). It seems to me that the date picker tries to read the data without passing the :name_parameter and therefore fails.
Any idea on how to resolve this, or is this a bug?
SELECT
id,
date --SQL data type "date"
FROM
my.table
WHERE
name = :name_parameter
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2024 02:14 PM
This happens because all dependent parameters must be specified for the query to execute successfully. Try setting a default value for your parameter to ensure it’s always provided. Additionally, consider adding start_date and end_date parameters to control the date range independently.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-03-2024 02:14 PM
This happens because all dependent parameters must be specified for the query to execute successfully. Try setting a default value for your parameter to ensure it’s always provided. Additionally, consider adding start_date and end_date parameters to control the date range independently.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-12-2024 04:46 AM
Thanks a lot. I guess this was a case of not seeing the forest for the trees. But still, maybe the could add a tooltip or so for this field.
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/582998B45490C7019731A5B3A872C751/responsive_peak/images/icon_anonymous_message.png)