Query once, use many

  • What Grafana version and what operating system are you using?
    Azure managed Grafana v10.4.7

  • What are you trying to achieve?
    I have a costly query returning about 7 or 8 columns and about 9k rows. I want to create multiple views based off this data like count, count per different category (stored in different columns). I want to run this query only once when dashboard loads and then utilize the single output for multiple graphs. I was exploring dashboard variables but so far not successful. I want to know if I can really use dashboard variables for this scenario. Are there any other better ways to achieve this?

  • How are you trying to achieve it?
    I tried using dashboard variables.

  • What happened?
    I am not successful so far. For example, I don’t know what data source I should use.