I used to check the number of application failed ,Killed across the cluster and i use tsquery for that
select counter_delta(apps_completed_rate),counter_delta(apps_failed_rate),counter_delta(apps_killed_rate) where category=YARN_POOL and serviceName="YARN";
But it never account the failed/killed application and for the same date i use to get some failed application .
@nickk Do you mind give more details about the mismatch or so? Like a screenshot of timeseries charts for that query, and a screenshot of list of failed/killed applications from 'YARN Applications' page.