Prometheus for monitoring Airflow DAGs

We are using Prometheus for Airflow DAGs monitoring. How to get the only last run status of DAG, like whether failed or successful?
We tried using below queries:
For Success - count(last_over_time(airflow_dagrun_duration{kubernetes_namespace=“$namespace”}[1h])) by (dag_id)
For Failure -
count(last_over_time(airflow_dagrun_failed{kubernetes_namespace=“$namespace”}[1h])) by (dag_id)

Some of the DAGs are showing in both failed and success, as they run more than once within specific time (hourly/daily).

Can we get only last status of DAGs using PromQL?