# Pie chart with multiple terms **URL:** \ **Category:** Kibana\ **Created:** [January 5, 2024, 6:35pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482 "2024-01-05T18:35:28Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![CargoBikoMeter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cargobikometer/32/101615_2.png) [@CargoBikoMeter](https://discuss.elastic.co/u/CargoBikoMeter)\ **Post date:** [January 5, 2024, 6:35pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/1 "2024-01-05T18:35:28Z")
Hi, I want to create a pie chart with four different terms car\_total, heavy\_total, bike\_total and ped\_total. For the terms the percentage from the sum (car\_total +heavy\_total +bike\_total + ped\_total) should be visible. The pie chart should look like the chart "Modal split" at [Telraam](https://telraam.net/discourse/location/9000002074/2023-12-28/2023-12-28) What is the best way to do this in Kibana? Currently I work on an ELK setup, which uses the open data from our [ADFC-TK](https://berlin-zaehlt.de/csv/) system . ---
**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\ **Post date:** [January 9, 2024, 1:23am UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/2 "2024-01-09T01:23:12Z")
Hello @CargoBikoMeter, You can create a pie chart using a terms aggregation. Example: ![IMG_2582](https://us1.discourse-cdn.com/elastic/original/3X/c/a/ca1da04f2b14ce64f0e3aa8d17fa9d2a538a2e2d.jpeg) To enable the percentage for each term, enable ‘show percentage’ in options-\>label settings. ---
**Author:** ![CargoBikoMeter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cargobikometer/32/101615_2.png) [@CargoBikoMeter](https://discuss.elastic.co/u/CargoBikoMeter)\ **Post date:** [January 9, 2024, 2:49pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/3 "2024-01-09T14:49:21Z")
Hi Priscilla, my problem is, to view one pie chart with four different terms. It would be nice if someone can provide an example pie with four different terms. Regards ---
**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\ **Post date:** [January 9, 2024, 5:05pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/4 "2024-01-09T17:05:21Z")
If you want a sum of different values you might want to consider adding a [formula](https://www.elastic.co/guide/en/kibana/current/lens.html#lens-formulas). ![Screen Shot 2024-01-09 at 12.07.11 PM](https://us1.discourse-cdn.com/elastic/original/3X/6/1/610374ca9746541948ccce160b434aa048f6ac81.png) ---
**Author:** ![CargoBikoMeter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cargobikometer/32/101615_2.png) [@CargoBikoMeter](https://discuss.elastic.co/u/CargoBikoMeter)\ **Post date:** [January 16, 2024, 3:27pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/5 "2024-01-16T15:27:04Z")
Hello Priscilla, the formula now works in our [dashboard](https://dashboard.berlin-zaehlt.de) for the metric charts with the percentages of the individual terms of the total. In the Pi chart, I have not yet managed to display the four different terms in a common circle. Formula for Pedestrians Metric: sum(ped\_total) / (overall\_sum(sum(bike\_total)+sum(car\_total)+sum(heavy\_total)+sum(ped\_total))) By Roland ---
**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\ **Post date:** [January 25, 2024, 9:25pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/6 "2024-01-25T21:25:51Z")
Is the formula you shared working? Were you unable to split slices by terms as I mentioned, or do you want something different? ---
**Author:** ![CargoBikoMeter](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cargobikometer/32/101615_2.png) [@CargoBikoMeter](https://discuss.elastic.co/u/CargoBikoMeter)\ **Post date:** [February 12, 2024, 10:37am UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/7 "2024-02-12T10:37:41Z")
Hi, it is working, please see: [Elastic](https://dashboard.berlin-zaehlt.de/s/bzm/app/dashboards#/view/9bbb53b5-a0a9-4f06-9dbe-a23143c431e2?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-7d%2Fd,to:now))) ---
**Author:** ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)\ **Post date:** [February 20, 2024, 7:21pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/8 "2024-02-20T19:21:52Z")
Hey, that's great. Thanks for sharing it. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 19, 2024, 7:22pm UTC](https://discuss.elastic.co/t/pie-chart-with-multiple-terms/350482/9 "2024-03-19T19:22:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.