Calculate success rate for multiple sites and display in the one chart

i have a query A give me the the numerator A per siteC
i have a query B give me the the denominator B per siteC

so I have A/B which gives my success rate per siteC
and this I can plot in a time series chart for siteC

But how can i get the success rate in the same chart for multiple sites - site D, E and F… etc

I want to successrate across all sites in the one chart.

example pic below of success rate for 1 site

  • What Grafana version and what operating system are you using?
    8.0.3

  • What are you trying to achieve?
    see above

  • How are you trying to achieve it?
    see above

  • What happened?
    see above

  • What did you expect to happen?
    n/a

  • Can you copy/paste the configuration(s) that you are having problems with?
    n/a

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    n/a

  • Did you follow any online instructions? If so, what is the URL?
    n/a