cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Lakeview dashboard dynamically change filter values

EDDatabricks
Contributor

Greetings everyone,

We are trying to implement a series of visualizations. All these visualizations have queries assigned to them in the form of โ€œ Select * from test table where timestamp between :Days start and :Days endโ€. The is also a filter applied to each one of those parameters so we can check the time period we want. We would like to have a schedule that refreshes once a day and dynamically uses the filters (for example the start time should be the current timestamp - 7 days and the end time should be the current timestamp). Is there any way to do that? Moreover is there anyway to setup a pre set warehouse that this dashboard will run on after without choosing it manually in the first time?

Also during the development of the lakeview dashboards we noticed 2 inconsistencies with the dashboard. The first one is that the filter wouldnโ€™t let us choose a different date (we don't know how to replicate this one).
The other one is that half of the visualizations were displaying data and some of them were not with the error โ€œMissing selections for parametersโ€.

To replicate this do the following:

  1. Create queries in the data tab and have them to have parameters (2 of them)  in the form of โ€œ:parameterโ€ with the type of โ€œ Date and Time โ€œ.
  2. Leave those queries without a Default value for the parameters as shown in the screenshot below.
    EDDatabricks_0-1712826834624.png

     

  3. Create 2 filters. One of them has one parameter and the other one has the other.
  4. If you try to set the value of the filters and refresh the dashboard some visualizations return this error message.
    EDDatabricks_1-1712826864074.png

Also we noticed that if you don't have a default value in the query parameter associated with the visualization you canโ€™t edit the visualization. But if you add a default value in the query parameter, then edit and then remove the default value the dashboard remains as edited. Is there a way to not have a default parameter and edit the visualization without going through this?

 

0 REPLIES 0

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