Eliminate state. If you can’t, make it visible.
I do this all the time. Ever get questions like “does this include cancelled orders?” Add a dashboard filter with exactly one preselected choice: “Cancelled - NO”
In Looker this is called always_filter
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!