I am trying to display the AWX dashboard job status graph in Grafana. We are sending the AWX metrics to Prometheus. So we are trying to display with the Prometheus data. While I try to add query in the Grafana, the data is not exactly co-relates with what I see in Grafana. To give you an example, The total successful jobs for a day range between 1200 to 2500 but in the Grafana it showing upto 200000.
Please let me know if I need to make changes in the below query:
Grafana (Prometheus) query:
Job Successful:
sum(awx_status_total{status=“successful”}) - sum(awx_status_total{status=“successful”} offset 24h)
Job failures:
increase(awx_status_total{status=~“failed|successful”}[24h])
Screenshot of AWX and Grafana: