What I would like to show on my graph is value that each system has? Is there where I need to use this first query as a subquery?? I’ve very new to PromQL and I haven’t found any good tutorials to practice the syntax. If this was SQL I would write a query like this
JOIN system2 ON system1.sku = system2.sku
WHERE (system2.quantity - system1.quantity) != 0
ORDER BY time
My goal if I were to look at a single SKU, the graph would show 2 lines, one for each system’s value. Then I could observe over time their relative difference.