# Is it possible to show Pie chart in such situation?
**URL:** https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781
**Category:** Kibana
**Created:** [February 15, 2016, 12:32pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781 "2016-02-15T12:32:45Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@kacemrostom](https://discuss.elastic.co/u/kacemrostom)
#### Post date: [February 15, 2016, 12:32pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781/1 "2016-02-15T12:32:45Z")
Hello everyone one,
So i have around 100 docs stored in Elasticsearch, each one have this following part:
`page_storytellers_by_city: { USA: X, UK: Y, France: Z}`
It indicates the number of visitor from many countries in a given day.
What i want to do is to SUM all numbers for each city in all docs then add them to an overall Pie Chart (that shows % for each city in all docs at once)?
If it's not possible. should i use the format of tables to achieve that ('i.e
`page_storytellers_by_city: [USA: X, UK: Y, France: Z]` which i can do by restructuring the docs
)
Thanks in advance.
---
### Author:  [@kacemrostom](https://discuss.elastic.co/u/kacemrostom)
#### Post date: [February 17, 2016, 11:41am UTC](https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781/2 "2016-02-17T11:41:36Z")
Any answer?
---
### Author:  [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [February 19, 2016, 2:12pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781/3 "2016-02-19T14:12:24Z")
As this is a nested structure, Kibana can't run aggregations over the values in the nested part of the doc (see [here](https://github.com/elastic/kibana/issues/1084)). I'd suggest denormalizing or using "include\_in\_parent" (1.x) or "copy\_to" (2.x) Elasticsearch mapping to flatten the field, so that you can run aggregations on it.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:01pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-pie-chart-in-such-situation/41781/4 "2017-07-06T14:01:40Z")