Query: project_failed_pipeline_count

select
  'Failed Pipelines' as label,
  count(l.*) as value,
  case
    when count(l.*) > 0 then 'alert'
    else 'ok'
  end as type
from
  gitlab_my_project p
  join gitlab_project_pipeline l on p.id = l.project_id
where
  l.status = 'failed';