# Count filtering visualization
**URL:** https://discuss.elastic.co/t/count-filtering-visualization/333527
**Category:** Kibana
**Created:** [May 16, 2023, 5:59am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527 "2023-05-16T05:59:49Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@clmtb](https://discuss.elastic.co/u/clmtb)
#### Post date: [May 16, 2023, 5:59am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/1 "2023-05-16T05:59:49Z")
Hi all,
I am trying to create a pretty simple visualization in Kibana in TSVB Table, with the count of different fields but with a filter applied. To be more precise, I want to get the count of every values higher than 1 for each IDs that I have and for different fields, like represented in the example below:
I also tried to go in the "Options" panel in TSVB but I cannot access the fields on which I want to apply the filter in the list...
Could anyone help me on this issue ?
Thanks in advance.
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [May 16, 2023, 8:08am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/2 "2023-05-16T08:08:41Z")
You can't do this in TSVB, but maybe you can do it in Lens. I am just trying to understand exactly what you want.
So you have an aggregation of the field1, let's say average and you would like to render only the average(field1) \> 1? Do I get it correctly?
---
### Author:  [@clmtb](https://discuss.elastic.co/u/clmtb)
#### Post date: [May 16, 2023, 9:24am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/3 "2023-05-16T09:24:52Z")
Thanks for your answer, and sorry if I wasn't clear enough.
For each IDs, I have one value each hour, and this value can be from 1 to 9.
What I want to do, is just to create a simple table with all my IDs as lines, and get the count for all the value that are higher than 1 during one day. For instance, if I get 13 times a value higher than 1 (so from 2 to 9), I want "13" to be displayed in my table, and do the same for all IDs and all fields.
Hope this is more precise!
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [May 16, 2023, 9:57am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/4 "2023-05-16T09:57:39Z")
yes I think you could do it in Lens with the filter by setting
---
### Author:  [@clmtb](https://discuss.elastic.co/u/clmtb)
#### Post date: [May 17, 2023, 7:07am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/5 "2023-05-17T07:07:27Z")
Thanks a lot for the answer.
Excuse me, what version of Kibana are you using ?
Because I don't have the same interface when using Lens:
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [May 17, 2023, 7:26am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/6 "2023-05-17T07:26:01Z")
@clmtb this interface doesnt look very familiar to me. Can you share your kibana version?
---
### Author:  [@clmtb](https://discuss.elastic.co/u/clmtb)
#### Post date: [May 17, 2023, 8:05am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/7 "2023-05-17T08:05:06Z")
I am currently using the version 7.7.1 of Kibana
---
### Author:  [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)
#### Post date: [May 17, 2023, 8:06am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/8 "2023-05-17T08:06:51Z")
Oh you are in a very early version of kibana. We added it later, I dont remember the version but the latest 7 version (7.17) has this setting.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 14, 2023, 8:06am UTC](https://discuss.elastic.co/t/count-filtering-visualization/333527/9 "2023-06-14T08:06:57Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.