# How To Create a Pie Charts by using a JSON data?
**URL:** https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620
**Category:** Kibana
**Created:** [January 2, 2019, 9:38am UTC](https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620 "2019-01-02T09:38:53Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@mark\_jerf](https://discuss.elastic.co/u/mark_jerf)
#### Post date: [January 2, 2019, 9:38am UTC](https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620/1 "2019-01-02T09:38:53Z")
hi,
I have a statistics dataset, which would be updated every hour. the format of the dataset is json, which like:
```
{ 'input_time' : '2019-01-02 10:30:00', 'num_a' : 100, 'num_b' : 300, 'num_c' : 200, 'num_d' : 500 }
```
I want to create a Pie Charts by using the data (num\_a, num\_b, num\_c, num\_d), unfortunately, Kibana could not do it.
my Kibana version is 6.4.2, any idea would be appreciate.
thanks.
Mark
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [January 7, 2019, 12:10pm UTC](https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620/2 "2019-01-07T12:10:46Z")
Hello,
they way the data looks right now it would be rather difficult to build pie chart in Kibana.
What i would recommend is to split each document into 4 separate documents, like this:
```auto
{ 'input_time' : '2019-01-02 10:30:00', 'field_name': 'num_a', 'field_value': 100}
{ 'input_time' : '2019-01-02 10:30:00', 'field_name': 'num_b', 'field_value': 300}
{ 'input_time' : '2019-01-02 10:30:00', 'field_name': 'num_c', 'field_value': 200}
{ 'input_time' : '2019-01-02 10:30:00', 'field_name': 'num_d', 'field_value': 500}
```
Then you can do a pie chart with Split by Terms on the `field_name` field. Although, it depends on what you want to do with the data from the pie chart as the default one is a bit limited in what it can do. For any extra calculations and splits you will have to build your own piechart using Vega: [https://www.elastic.co/guide/en/kibana/current/vega-graph.html](https://www.elastic.co/guide/en/kibana/current/vega-graph.html)
---
### Author:  [@mark\_jerf](https://discuss.elastic.co/u/mark_jerf)
#### Post date: [January 10, 2019, 2:15am UTC](https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620/3 "2019-01-10T02:15:49Z")
thank you very much! it works, and I will try to use Vega soon.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 7, 2019, 2:15am UTC](https://discuss.elastic.co/t/how-to-create-a-pie-charts-by-using-a-json-data/162620/4 "2019-02-07T02:15:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.