# Bar chart - Aggregate by Field1 or Field2
**URL:** https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379
**Category:** Kibana
**Created:** [February 16, 2021, 4:12am UTC](https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379 "2021-02-16T04:12:19Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [February 16, 2021, 4:12am UTC](https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379/1 "2021-02-16T04:12:19Z")
Hello,
I have documents with 2 fields that I would like to use for aggregation.
The document will look something like
```auto
"_source" : {
"name" : "name_value",
"id" : "id_value",
...
...
}
```
But, some names might be missing/empty.
I would like to show a bar chart (For example) that shows count by name, but if the name is empty present the id instead.
Is this possible? How?
If not, any alternatives?
Thanks!
---
### Author:  [@brianseeders](https://discuss.elastic.co/u/brianseeders)
#### Post date: [March 2, 2021, 10:39pm UTC](https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379/2 "2021-03-02T22:39:19Z")
Hey @AClerk,
Take a look at [Scripted Fields](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html). I believe these will do what you want. You can do aggregations on them as well.
Note that these are computed on-the-fly, and are potentially more resource-intensive. The better option, if you can do it, is to add another field to the record at index time that contains the correct value. That way, it's already there and indexed by Elasticsearch.
Brian
---
### Author:  [@AClerk](https://discuss.elastic.co/u/AClerk)
#### Post date: [March 2, 2021, 11:36pm UTC](https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379/3 "2021-03-02T23:36:44Z")
Hi @brianseeders
Thanks for your reply.
I am aware of this solution but thought maybe there is a better way to do this.
Cheers!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 30, 2021, 11:36pm UTC](https://discuss.elastic.co/t/bar-chart-aggregate-by-field1-or-field2/264379/4 "2021-03-30T23:36:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.