I have 2 dashboards with the exact same filters. if I select a few filters on one dashboard and then go look at another dashboard, how can I carry my selection to the other dashboard instead of having to reselect everything all over again?
Solved! Go to Solution.
You can try to have a lookml dimension in a visualization at the bottom which would build url based on current filters( see Emma's response for url info) (concat(url ending in ?,filter1=cool+filter&cool+filter2)). Then just have a bit of custom html to make it cleaner and easier to follow.
Do you know if we can use ${dimension} in text or markdown or even tile name? That would make it even cleaner.
Hey there! I think the best way to go about this would be to grab the filters from one dashboard's URL and paste them into the second dashboard. If the filters are exactly the same between the two you can copy the values between them.
You can grab the URL from the first dashboard, which should look something like the following:
LOOKERINSTANCE/dashboards/DASHBOARDNUMBER?Country=United+States&Date=6+month+ago+for+6+month&State=California
The part following the question mark contains the filters for the dashboard. If you copy that part and paste it after the URL in the second dashboard the filters will be applied to the second dashboard.
If the filters are used often and need to be used on multiple dashboards, consider adding them to the LookML for an Explore.
Hope this helps!
Hey Emma, that sounds great and would work for me, but is there a way for this to happen automatically as we switch between dashboards for non tech people? Example below if I had a button that linked to another looker dashboard, can the filters be carried over automatically?
You can try to have a lookml dimension in a visualization at the bottom which would build url based on current filters( see Emma's response for url info) (concat(url ending in ?,filter1=cool+filter&cool+filter2)). Then just have a bit of custom html to make it cleaner and easier to follow.
Do you know if we can use ${dimension} in text or markdown or even tile name? That would make it even cleaner.
Is anyone able to share more details on how this was resolved please? Thanks in advance!