Kibana Visualization filtering data based on aggregation

I have requirement that to show the count of running jobs and completed in Pie chart . I am receiving status of jobs in real time . To show the count of the jobs that are currently in running state I have to filter those jobs which are already completed (e.g Job a) . Please suggest a way to to do this.

Job timestamp Status
job a 1639381300 Running
job a 1639381301 Running
job a 1639381302 Complted
job b 1639381301 Running

OutPut(Pie Chart)

Count of jobs completed jobs =1
Count of jobs running jobs =1

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.