This is a technique for loading dashboards with single value tiles that have the same WHERE clause.
Instead of making a single query using filters for each Look and a single measure or dimension, this example returns an entire row with every single value desired:
From this single query, we can create multiple single-value visualization tiles for our dashboard. In this example we will call it Single Value Dashboard.
We can do this by:
- Hiding every dimension and measure, except for the desired field we want to show in the Look:
- Saving the Single Value visualization in the same Dashboard, for each measure and dimension:
- Then, our dashboard will produce the different tiles or Looks (according to how you saved each visualization) off the same Explore query:
This greatly reduces the load time used in running parallel queries on the database which uses the same WHERE filters, so it improves performance and reduces database load.