# Getting all values from ElasticSQL in canvas

**URL:** <https://discuss.elastic.co/t/getting-all-values-from-elasticsql-in-canvas/169067>\
**Category:** Elasticsearch\
**Created:** [February 19, 2019, 4:46pm UTC](https://discuss.elastic.co/t/getting-all-values-from-elasticsql-in-canvas/169067 "2019-02-19T16:46:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel\_Plazas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miguel_plazas/32/40038_2.png) [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\
**Post date:** [February 19, 2019, 4:46pm UTC](https://discuss.elastic.co/t/getting-all-values-from-elasticsql-in-canvas/169067/1 "2019-02-19T16:46:45Z")

</div>

Hi, Currently i'm trying to plot a pie chart using canvas, my target is plot the percente (%) of a single column values, this is my closer aproach:

![image](https://us1.discourse-cdn.com/elastic/original/3X/1/d/1df0e82ab5ad9af871724f4e87fda25e6afa88af.png)

```
filters
| essql 
  query="SELECT * FROM demo_finanzas_21 WHERE contrapartes='Alan Juarez' AND divisas='USD'"
| pointseries color="ganancia" size="size(factor_ganancia)"
| pie hole=45 labels=true legend=false 
  palette={palette "#882E72" "#B178A6" "#D6C1DE" "#1965B0" "#5289C7" "#7BAFDE" "#4EB265" "#90C987" "#CAE0AB" "#F7EE55" "#F6C141" "#F1932D" "#E8601C" "#DC050C" gradient=false}
| render

```

If i hardcode the count value of essql as follows:

`essql query="SELECT * FROM demo_finanzas_21 WHERE contrapartes='Alan Juarez' AND divisas='USD'" count=2000`

I'm getting another plot:

![image](https://us1.discourse-cdn.com/elastic/original/3X/0/d/0d0242313979ebed3e7f2f87a9f5da49b15d1240.png)

Is there a way to plot this pie chart getting all values?

---

<div class="post-metadata">

**Author:** ![Miguel\_Plazas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/miguel_plazas/32/40038_2.png) [@Miguel\_Plazas](https://discuss.elastic.co/u/Miguel_Plazas)\
**Post date:** [February 20, 2019, 3:46pm UTC](https://discuss.elastic.co/t/getting-all-values-from-elasticsql-in-canvas/169067/2 "2019-02-20T15:46:26Z")

</div>

This is the solution:

```
filters
| essql 
  "SELECT COUNT(*) as conteo, ganancia FROM demo_finanzas_21 WHERE divisas='USD' AND contrapartes='Alan Juarez' GROUP BY ganancia"
| pointseries color="ganancia" size="conteo"
| pie hole=45 labels=true legend=false palette={palette "#7ECAE3" "#003A4D" gradient=true}
| render

```

![image](https://us1.discourse-cdn.com/elastic/original/3X/e/c/ec8caa37c87c53c1c12de538eaf295c4b471934b.png)

---

<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:** [March 20, 2019, 3:46pm UTC](https://discuss.elastic.co/t/getting-all-values-from-elasticsql-in-canvas/169067/3 "2019-03-20T15:46:26Z")

</div>

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