What Grafana version and what operating system are you using?
Grafana Cloud, MacOS 14.7.6
What are you trying to achieve?
Getting a ratio between multiple values in multiple dataframes and displaying the results in a time-series visualization.
The dataframes come from two different queries:
-The first query is from PromQL, getting the rate of requests for each host
-The second query is from LogQL, getting the rate of Loki logs for each host
Each query produces 1 dataframe time-series per host.
From the PromQL result there will be a value for host1 at time X (e.g. host1_promQL). For the LogQL result there will also be a value for host1 at time X (e.g. host1_logQL). There is also going to be a host2_promQL, host2_logQL and so on…
I want to get the ratio between host1_promQL and host1_logQL, host2_promQL and host2_logQL and so on.
How are you trying to achieve it?
I put each query into one table panel each, and I transformed them into a long series.
The I created a third panel where I added both panels under a dashboard datasource. Also in the third panel I did a join by field OUTER(time-series) and host. This joined the data but I only see one timestamp per host. It did not join all the other timestamps.
What happened?
Data joined only for one timestamp per host. Other timestamps were lost. So even if I add a new field with binary operation, I will be unable to get the ratio for all hosts in all timestamps.
What did you expect to happen?
Be able to get the ratio per host for all timestamps and display it in a time-series visualization.
Can you copy/paste the configuration(s) that you are having problems with?
The configuration is as stated above, but I can give more details if needed.
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
No
Did you follow any online instructions? If so, what is the URL?
No