# Count of true values in Kibana data table
**URL:** https://discuss.elastic.co/t/count-of-true-values-in-kibana-data-table/252052
**Category:** Kibana
**Created:** [October 14, 2020, 1:42pm UTC](https://discuss.elastic.co/t/count-of-true-values-in-kibana-data-table/252052 "2020-10-14T13:42:04Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@DougR](https://discuss.elastic.co/u/DougR)
#### Post date: [October 14, 2020, 1:42pm UTC](https://discuss.elastic.co/t/count-of-true-values-in-kibana-data-table/252052/1 "2020-10-14T13:42:04Z")
I'm doing a Kibana data table which looks like:
| Environment | Field1 | Field2 | Field3 | Field4 |
| --- | --- | --- | --- | --- |
| Dev | Sum | Sum | Sum | ??? |
| QA | Sum | Sum | Sum | ??? |
| Stage | Sum | Sum | Sum | ??? |
| Prod | Sum | Sum | Sum | ??? |
`Field1`, `Field2`, and `Field3` are numeric fields, and I want the sum of those - no problem. However, `Field4` is a Boolean field. What I need is to have `Field4` be the number of `true` values in the field.
In SQL, I would do:
```sql
select
sum(case 1 when 't.Field4' else 0 end) as Field4
from table t
```
I assume there's a way to do the same in a Kibana data table, probably using advanced field configuration and either `sum` or `count`, but I'm not certain where to start.
---
### Author:  [@ylasri](https://discuss.elastic.co/u/ylasri)
#### Post date: [October 14, 2020, 1:46pm UTC](https://discuss.elastic.co/t/count-of-true-values-in-kibana-data-table/252052/2 "2020-10-14T13:46:42Z")
That can be handled by adding a scripted field called Field4\_SF as follow then use it with sum in your data table
```
if( !doc['t.Field4'].empty && doc['t.Field4']) {
return 1;
} else return 0;
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 11, 2020, 2:35pm UTC](https://discuss.elastic.co/t/count-of-true-values-in-kibana-data-table/252052/4 "2020-11-11T14:35:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.