Last time when value is non zero

Grafana Prometheus
1

Hi
I’m running batch jobs and when the job runs it updates values with 1 and other times zero. I need to have a table panel which shows when the job completed last. I’m able to see the graph but I need as table list with last time when it was 1

image
image3360×466 33.1 KB

2

Simply. open the edit panel view, go to visualization tab, change the panel to ‘Table’ from ‘Grpah’ and then modify the query -
select jobID, jobName, max(<datetime_column_name>) from job where status = 1 group by jobID, JobName

3

Hi I’m using prometheus , can i use select query on that ?

4

Try the solution given here - https://www.robustperception.io/graph-top-n-time-series-in-grafana