range query - How to calculate the duration in which some Prometheus metric has specific value aggregated by some label

Question

My application has several jobs that return job_status gauge metric with values 0, 1, 2, 3, 4, 5. Status 1 - means 'running'. Jobs can be 'running' in parallel or not, sometimes with intersections (see blue lines):

I need to calculate how much time at least 1 job was in status 1 ('running') - it can be visualized as a sum of red lines. Additional problem is that I need to aggregate this by job_name label (there are several jobs with the same job_name, but different job_id).

question from:https://stackoverflow.com/questions/65651859/how-to-calculate-the-duration-in-which-some-prometheus-metric-has-specific-value

Answer 1

Waitting for answers