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

FLK
Databricks Partner

‎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

 

0 Kudos

Rafael-Sousa
Contributor II

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

Rafael Sousa

View solution in original post

FLK
Databricks Partner

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

FLK_0-1731415548674.png

 

 

0 Kudos