# Pie chart with percentage

**URL:** <https://discuss.elastic.co/t/pie-chart-with-percentage/272168>\
**Category:** Kibana\
**Tags:** canvas\
**Created:** [May 5, 2021, 10:23am UTC](https://discuss.elastic.co/t/pie-chart-with-percentage/272168 "2021-05-05T10:23:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [May 5, 2021, 10:23am UTC](https://discuss.elastic.co/t/pie-chart-with-percentage/272168/1 "2021-05-05T10:23:08Z")

</div>

Hi,  
I've written this query:

```auto
SELECT idMaxNet,COUNT(tagId) as num FROM "itt_data_bridgenuzoo" WHERE date >= CURRENT_DATE - INTERVAL '7' DAY AND idMaxNet!=0 AND (idMaxNet=128 OR idMaxNet=129 OR idMaxNet=130 OR idMaxNet=131) GROUP BY idMaxNet

```

and I have this result:

|idMaxNet |num |  
129 25  
131 29

I would put this data in a pie chart, with percentage. So: 100% is 25+29 = 54, than "129" is 46.3%, while "131" is 53.7.

how can I do?  
Thanks

---

<div class="post-metadata">

**Author:** ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)\
**Post date:** [May 6, 2021, 11:08am UTC](https://discuss.elastic.co/t/pie-chart-with-percentage/272168/2 "2021-05-06T11:08:31Z")

</div>

```auto
filters group="group1" ungrouped=true
| essql 
  query="SELECT COUNT(idMaxNet) as num,idMaxNet FROM \"itt_data_bridgenuzoo\" WHERE date >= CURRENT_DATE - INTERVAL '7' DAY GROUP BY idMaxNet"
| mapColumn name="labels" 
  expression={getCell "idMaxNet" | switch {case 131 then="Net 131"} {case 128 then="Net 128"} {case 129 then="Net 129"} {case 130 then="Net 130"} default="Altre Net"}
| pointseries color="labels" size="num"
| pie hole=50 
  palette={palette "#01A4A4" "#CC6666" "#D0D102" "#616161" "#00A1CB" "#32742C" "#F18D05" "#113F8C" "#61AE24" "#D70060" gradient=false} labels=true legend="ne"
| render

```

I had created groups and I had not set the variable correctly at the beginning of the expression

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 3, 2021, 11:08am UTC](https://discuss.elastic.co/t/pie-chart-with-percentage/272168/3 "2021-06-03T11:08:33Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.