# Kibana Visualization filtering data based on aggregation **URL:** \ **Category:** Kibana\ **Created:** [December 13, 2021, 9:34am UTC](https://discuss.elastic.co/t/kibana-visualization-filtering-data-based-on-aggregation/291610 "2021-12-13T09:34:42Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![anas\_pp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anas_pp/32/98804_2.png) [@anas\_pp](https://discuss.elastic.co/u/anas_pp)\ **Post date:** [December 13, 2021, 9:34am UTC](https://discuss.elastic.co/t/kibana-visualization-filtering-data-based-on-aggregation/291610/1 "2021-12-13T09:34:42Z")
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 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 10, 2022, 9:34am UTC](https://discuss.elastic.co/t/kibana-visualization-filtering-data-based-on-aggregation/291610/2 "2022-01-10T09:34:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.