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
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
Hi I’m using prometheus , can i use select query on that ?
Try the solution given here - https://www.robustperception.io/graph-top-n-time-series-in-grafana