Hi Grafana comunnity.
Can you help me with this type of issue?
We have Grafana (with Influxdb source) weekly dashboard for gathering histogram of our Jenkins pipelines. And I would like to ask you if there is any way how to show only one final result per day (there are many of runs per day because of troubleshooting etc.). We would like to “mark green if there is at least one record green per day” - regardless of results of rest of the records.
Our influxdb query:
SELECT build_result_ordinal FROM “jenkins_data” WHERE (“project_name” = ‘pipeline-x’ AND $timeFilter)
Results (0 means successful):
day 1:
0
0
2
day 2:
2
2
0