Excluding filter from a chart
Hello!
How can I make a chart be "immune" to dashboard filters?
Example: A dashboard covering a country's performance (so it has a Country filter), where I also want to add a global average performance chart, in order to compare... How can I make that second chart NOT be affected by the dashboard filter? I tried adding a chart-level filter but it didn't do the trick...
-
Official comment
Add it at the dataset level with a different name. Here's a run through: https://www.loom.com/share/3312fe857c8e4c639cbc692d20fb75f3
Comment actions -
Hmm I guess that works but not for all (most!) of my use cases...
Let's say I have a dataset with all my orders. In a dashboard, I create a card with the number of orders in a particular date range (with a filter for that range), and I want to compare that with the number of orders from the last 30 days or something like that... or even from a different date range using another filter! this solution wouldn't work then, right? Maybe it would and I'm missing it
-
I hadn't thought about pre-calculating stuff at dashboard level BTW, so this was useful! Just not exactly what I was looking for
-
Reviving this question with a new use case, which might be easier to understand:
Let's say we have a dataset with the following data:Month | Views | Orders
Now, let's say I have a dashboard with a month filter and a Views card showing the number of views that month. But I also want to include a small line chart showing the evolution of that number through the last 12 months...
How could I do that? The only way I imagine is to have columns "Views -1M", "Views -2M" and so... but it's not a great solution.
Cheers!
-
Hi Gonzalo,
For this use case I would rename the month field from the query level for the historic line chart. This way when you do a dashboard filter on the field Month it will not recognize the changed name and won't filter on it. If you name the month field Month* or Date or _Month_ it will be immune from the dashboard filter. Just make sure to make the change at the query level.
Please sign in to leave a comment.
5 comments