I have many question tiles on my dashboard which are running extensive queries which increase the loading time. Is there a way I can automatically run the dashboard and once it gets all the values, I can dump the data in let's say excel or csv.
Hi @eginsea
There are multiple ways to optimize dashboards to run faster, but it depends on where the bottleneck is:
https://www.metabase.com/learn/data-diet/analytics/making-dashboards-faster.html
You could use Subscriptions to receive everything via email:
https://www.metabase.com/docs/latest/users-guide/dashboard-subscriptions.html
1 Like
Thanks for the quick reply. Dashboards running slower is one bottleneck. I created a dashboard and have filters for mentioning the experiment name for which I want the analysis. Let's say I have 50 experiments ["a001", "a002" ....] and want to subscribe(as you suggested) each experiment. How should I work that out?
@eginsea That would require 50 dashboards each with the filter set to a default value. Only the Enterprise Edition has the option to create individual filters per subscription:
https://www.metabase.com/docs/latest/users-guide/dashboard-subscriptions.html#enterprise-edition-customize-filter-values-for-each-dashboard-subscription
But if you're just looking to export data in this manner, then I don't think Metabase is the right tool for you.
1 Like