# Canvas kibana

**URL:** https://discuss.elastic.co/t/canvas-kibana/259230
**Category:** Kibana
**Created:** [December 21, 2020, 8:04am UTC](https://discuss.elastic.co/t/canvas-kibana/259230 "2020-12-21T08:04:18Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![salma\_widiarti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/salma_widiarti/32/78306_2.png) [@salma\_widiarti](https://discuss.elastic.co/u/salma_widiarti)
#### Post date: [December 21, 2020, 8:04am UTC](https://discuss.elastic.co/t/canvas-kibana/259230/1 "2020-12-21T08:04:18Z")

</div>

Hi all,  
I want to create data like this in canvas kibana  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/5/f5e4b58b74b75081e597164fa4cd3cca763897ce.png)

And this is my query essql

```auto
SELECT (labels.money::int) as a FROM "apm-*" WHERE labels.status = 'PAID'

```

When I preview the result the data type is already numeric  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/3/43d955bba9fa46bd893a84d5e4a3d8bab19c686b.png)

I have made the display value according to the alias

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/3/2381534b8700f835d3d6fc0766c44db4a5adc0b6.png)

but why the result like this  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3c805057cd8c618b290ae977e2010d3f0358cdca.png)

Any one can help me?

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 21, 2020, 9:29am UTC](https://discuss.elastic.co/t/canvas-kibana/259230/2 "2020-12-21T09:29:05Z")

</div>

This element requires a value between 0 and 1 to show a percentage, but as you can see in your table screenshot, your data is way bigger than 1. For the values shown in the table, what percentage would you expect to show?

---

<div class="post-metadata">

### Author: ![salma\_widiarti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/salma_widiarti/32/78306_2.png) [@salma\_widiarti](https://discuss.elastic.co/u/salma_widiarti)
#### Post date: [December 21, 2020, 12:21pm UTC](https://discuss.elastic.co/t/canvas-kibana/259230/3 "2020-12-21T12:21:42Z")

</div>

Actually I don't want to show data with percentage, I want to show the sum data table screnshoot (641,140,000)

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [December 21, 2020, 12:52pm UTC](https://discuss.elastic.co/t/canvas-kibana/259230/4 "2020-12-21T12:52:51Z")

</div>

If you select the element, on the right side you can click the "add" icon in the "Progress" section, then select "Maximum value". There you can set the maximum value to something besides 1:

 ![Screenshot 2020-12-21 at 13.52.00](https://us1.discourse-cdn.com/elastic/original/3X/5/1/510444de1f962e72146d00fb366bd3649fd67bdd.png) ![Screenshot 2020-12-21 at 13.52.05](https://us1.discourse-cdn.com/elastic/original/3X/5/9/59f989394f6209a17ec2ca309a06bd8d0aa88376.png)

---

<div class="post-metadata">

### Author: ![salma\_widiarti](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/salma_widiarti/32/78306_2.png) [@salma\_widiarti](https://discuss.elastic.co/u/salma_widiarti)
#### Post date: [December 22, 2020, 5:52am UTC](https://discuss.elastic.co/t/canvas-kibana/259230/5 "2020-12-22T05:52:25Z")

</div>

Thanks flash1293, your solution is worked..

---

<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: [January 19, 2021, 5:52am UTC](https://discuss.elastic.co/t/canvas-kibana/259230/6 "2021-01-19T05:52:44Z")

</div>

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