I’ve shown this example as a response to some posts and thought I would just add this here so it’s easy to find.
In this loom video I show how you can set up a tab for doing dashboards in a simple and clean way. This is using what we tend to refer to as a “helper table” with variables you can feed into a Query column to get your results.
Hopefully I’ve included enough info here to help you build this out for your project but certainly ask any questions if I didn’t explain something well enough.
that’s really useful!