Visualisation resets after saving question


this might be a special case, I however want to still want to get input on how to handle it best.

Currently, we are using Metabase with BigQuery on v0.44.3 and we restrict any BigQuery queries that do not filter for dates in Facttables for cost-saving purposes. This leads to the situation that any question itself in metabase must have a date filter in order to compute properly.

Now, the problem is working with dashboard and a dashboard date filter. As the dashboard filter only can further restrict a data range set on the question level and not expand it, we loose some flexibility. I understand this is intended behaviour and I see why SEE HERE.

A potential way around this would be to not restrict the question itself (this would mean the question would not load by itself) and only work with dashboard date filters. This works for some visualisations, however, for others it seems to reset the visualisation as you can see in the screenshot.

Let me know if this is not entirely clear or you need some diagnostic info from me. I would appreciate ideas, or anything else that comes to your mind on this topic.



Hi @kadmos
Sounds like you're looking for this: - upvote by clicking :+1: on the first post

I'm not sure why you are seeing this if you are filtering with no results, or if there are results. It should display the visualization if there's results, but if the columns change based on your filter, then you can get into problems. I cannot tell what the solution is without understanding the full question metadata /api/card/123, where 123 is the question ID.