Last time when value is non zero

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 -