cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

FLK
New Contributor II

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Rafael-Sousa
Contributor II

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

2 REPLIES 2

Rafael-Sousa
Contributor II

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

FLK
New Contributor II

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

 

 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group