I’m relatively new to grafana and require to build a new query that i want o put into a gauge and a table.
the gauge required is to reflect the request that are within SLA, near SLA breach and breached SLA’s
The information from prometheus is:
HELP bolt_bff_actions_count_total
TYPE bolt_bff_actions_count_total counter
bolt_bff_actions_count_total{applicationNo="2019030000000000105",ebo="NTTTOYOTA",sla="2019-03-19T15:53:46.103",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:50:46.103",timestamp_sla_warn="2019-03-19T15:52:46.103",tribe="NOT DEFINED YET",} 1.0
bolt_bff_actions_count_total{applicationNo="2019030000000000106",ebo="SERITI",sla="2019-03-19T15:53:56.485",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:50:56.485",timestamp_sla_warn="2019-03-19T15:52:56.485",tribe="NOT DEFINED YET",} 1.0
bolt_bff_actions_count_total{applicationNo="2019030000000000101",ebo="NTTTOYOTA",sla="2019-03-19T15:38:00.995",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:35:00.995",timestamp_sla_warn="2019-03-19T15:37:00.995",tribe="NOT DEFINED YET",} 1.0
bolt_bff_actions_count_total{applicationNo="2019030000000000103",ebo="SIGNIO",sla="2019-03-19T15:38:48.489",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:35:48.489",timestamp_sla_warn="2019-03-19T15:37:48.489",tribe="NOT DEFINED YET",} 1.0
bolt_bff_actions_count_total{applicationNo="2019035090000000104",ebo="BARLOWS",sla="2019-03-19T15:53:36.375",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:50:36.375",timestamp_sla_warn="2019-03-19T15:52:36.375",tribe="NOT DEFINED YET",} 1.0
bolt_bff_actions_count_total{applicationNo="2019030000000000107",ebo="SIGNIO",sla="2019-03-19T15:54:05.81",stage="PAYOUT",task_action="VALIDATE_DRIVERS_LICENSE",task_status="NEW",task_type="VALIDATE",timestamp_created="2019-03-19T15:51:05.81",timestamp_sla_warn="2019-03-19T15:53:05.81",tribe="NOT DEFINED YET",} 1.0