topic Re: Dashboards: date (range) picker doesn't go along with another parameterized filter in Warehousing & Analytics

Dashboards: date (range) picker doesn't go along with another parameterized filter

FLK — Thu, 24 Oct 2024 14:00:32 GMT

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

Re: Dashboards: date (range) picker doesn't go along with another parameterized filter

Rafael-Sousa — Sun, 03 Nov 2024 22:14:50 GMT

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.

Re: Dashboards: date (range) picker doesn't go along with another parameterized filter

FLK — Tue, 12 Nov 2024 12:46:45 GMT

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.