Lakeview dashboard dynamically change filter values

EDDatabricks — Thu, 11 Apr 2024 09:28:21 GMT

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:

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 “.
Leave those queries without a Default value for the parameters as shown in the screenshot below.
Create 2 filters. One of them has one parameter and the other one has the other.
If you try to set the value of the filters and refresh the dashboard some visualizations return this error message.

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?

topic Lakeview dashboard dynamically change filter values in Get Started Discussions

Lakeview dashboard dynamically change filter values