I have created a bunch of analyses and dashboards based on some different datasets. I am wondering if it’s possible to somehow stop an analysis or a dashboard from “loading” on startup (i.e. when I open the analysis/dashboard). My current experience is that when I open an analysis or dashboard, it loads all the data that I’ve included in the analysis, before you can apply filters and select what you want to analyse.
I would like to be able to apply my filters before the analysis/dashboard content loads. Is this possible, is it easily achievable and how do I do it?
Hi @Joony,
why do you want to do that? Because it’s loading to long or something else.
But maybe you can set the filter default to something less time expensive or create a “filter page” where you can select the filter and then go do dashboard.
I think there are a few solutions, depending on the reason why.
@ErikG Thanks for getting back. The reason is that for some of these analyses, I am using a big dataset so the loading time is the main reason. I am interested in understanding if I can work around this and select filters before I run the analysis.
The filter default is an option but it just seems like a less desirable workaround. How do I set a filter default anyway, if I’d like to try it out?
@ErikG Thank you. I tried this and it worked to some extent. I have a separate issue tied to this however.
I have some parameter controls that I’ve defined, e.g. Shops and Products. When I select a Shop, the Products dropdown changes based on my selection. So far so good. But I can not seem to limit the list of shops to show in the dropdown, it just shows everything I have in my dashboard dataset.
Is there a way to create a dropdown for shops that only shows Shop A, Shop C and Shop E, but NOT Shop B and D, and still using cascaded parameter controls? My dropdown shows literally every shop that exists in the dataset, and I want to get rid of shops that have barely any revenue. How do I go with this?
PS I am using “Link to dataset” and “Show relevant values only”. The reason to why I want to limit the shops shown in the dashboard is because the Products list is more than 1000 with all the shops, meaning the dropdown won’t even load values. I found that the only way to use parameters with a filter is to use “Custom Filter” as Filter Type, but this mode does not seem to allow you to select which Shops I want to show in the dashboard / dropdowns.
why not remove the shops from the dataset, if you are not looking into them anyway?
create a “shop group” based on revenue. E.g. A = revenue > 1 Mio, B = revenue 100k to 1 Mio and C = revenue <100k. create a filter for the group and put the shop filter in dependencie to it.
@ErikG Thanks for your help. We have a few different dashboards that rely on this same dataset, and creating multiple datasets to support these dashboards seems unnecessarily complex. In some reports we don’t necessarily need dropdown filters but we still want to show all the data that exists in the dataset (e.g. total revenue, total users) even if there are a lot of smaller values.
In my world there should be a way to define “hard filters” on what is shown in the analysis/dashboard in the first place, and then everything else can be built on top of those filters. Like creating a little box (the analysis/dashboard) within the larger box (the dataset). It makes it difficult not seemingly being able to limit the analysis dataset within the analysis itself. I would like to be able to say that “hey, only include Bananas, Oranges and Apples”. Then the dataset will only include data for Bananas, Oranges and Apples and only data for Shops that sell those fruit (because everything else was filtered out).
I assume there is no way, apart from limiting the dataset?
I will also try out your option 2 and see if I can find a way.
But when we are talking on dataset level. you could create a filter on “Bananas, Oranges and Apples”. then you should only see the corresponding shops.
“creating multiple datasets to support these dashboards seems unnecessarily complex” you could use a “master dataset” and create “sub datasets” where you can place you filter. thinking on database level its like database and datamart.
“In my world there should be a way to define “hard filters”” that would be the dataset. because it’s hard to use one field as “hard filte” and use it than again as filter. Maybe you can create a cascading filter with revenue. but somewhere you need to pre filter the shops.
@ErikG Thanks. It did work on a dataset level and I used that method to accomplish the above. Still kind of wish that there was a way to create hard filters inside the analysis section. I will try your “revenue cascade filter” and see if that might help.
Thanks again for your help on this. I really appreciate it.
