I am having troubles visualizing multiple prometheus datasource queries as a table. There are few articles on the topic and of those, the articles are few years old:
And this one looks similar but the PR’s and transforms provided do not match what I want to do:
I am interested in the general topic of aliasing values for the purpose of joining n metrics to create a table , for a correlation of sorts. I wish to join, for example, blackbox exporter metrics probe_success, probe_icmp_duration_seconds and expose the values of probe_success and probe_icmp_duration_seconds as separate fields with the join field being instance and drop any labels that are not relevant to the table… Once joined, I intend to display the resulting table as a Grafana table panel. I think the reason for the failure is because the result of the query is labelled ‘Value’ in both cases.
The closest sql query might look something like:
SELECT S.instance as instance, S.Value as success, D.Value as duration, S.instance as instance FROM probe_success as S, probe_icmp_duration_seconds as D WHERE S.Time = D.Time and S.instance = D.instance
Do you have any guidance?