Is there any way to join 2 metrics in plot editor and create a chart or Table.
Eg. Plot A have "otelcol_process_cpu_seconds" and Plot B "have cpu.utilization".
I need to create Plot C list data exist in B (cpu.untilization) but not exist in plot A(otelcol_process_cpu_seconds").
I tried with formula, but formula works only for math operations like B-A (single value) but not working for showing the listing data, I need to plot table shows host name not in "otelcol_process_cpu_seconds".
Count the plots each appears in - if the count is 2 it is in both A and B, therefore it can be removed from C. Now if it appears in (only) A, you can also remove it (since you are not interested in it).
I tried your approach like applying count to both A and B. C only gives the difference of A-B.
eg. cpu_unitlization have 20 count and "otelcol_process_cpu_seconds" have 15 count, C=20-15 =5.
I need to find the host name of the missing 5 from the "otelcol_process_cpu_seconds".
My work is to find the running and non-running otelcol agents from all running host machines. I dont find any use full metrics to achieve this