# Percentage Calculation in kibana **URL:** \ **Category:** Kibana\ **Created:** [August 15, 2020, 10:19am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090 "2020-08-15T10:19:45Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Ramadevi](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Ramadevi](https://discuss.elastic.co/u/Ramadevi)\ **Post date:** [August 15, 2020, 10:19am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/1 "2020-08-15T10:19:45Z")
Hi Team, Our goal is to build table in the below format | Marketing | Operating | Count | Total | AF | FL | Total(%) | AF(%) | FL(%) | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | UA | UA | 9415 | 24 | 17 | 7 | 0.25 | 0.18 | 0.07 | | UA | LH | 47 | 6 | 6 | 0 | 12.77 | 12.77 | 0 | We are able to create below format using data-table | Marketing | Operating | Count | Total | AF | FL | | --- | --- | --- | --- | --- | --- | | UA | UA | 9415 | 24 | 17 | 7 | | UA | LH | 47 | 6 | 6 | 0 | Percentages should be calculated w.r.t Count We tried with scripted fields for calculating percentage, but couldn't calculate percentage and we got to know that scripted fields are calculated for each document due to which we couldn't achieve it. Please refer below for more details - [Division in Scripted field](https://discuss.elastic.co/t/division-in-scripted-field/244715) Our current version of kibana is 7.4.2. Could you please suggest best possible way to implement this. Also do let us know if we can achieve this by taking latest kibana version. Thanks & Regards, Ramadevi ---
**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:** [August 18, 2020, 8:00am UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/2 "2020-08-18T08:00:00Z")
The TSVB table visualization allows you to calculate percentages of other columns, but you can't use multiple buckets (like Marketing and Operating in your example). I think right now this is only possible in Canvas as you can use SQL there to query your table. ---
**Author:** ![Ramadevi](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Ramadevi](https://discuss.elastic.co/u/Ramadevi)\ **Post date:** [August 18, 2020, 1:44pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/3 "2020-08-18T13:44:53Z")
Hi Joe, Our goal is to implement table and send mail with table. When we checked Canvas, we could only see download format as pdf but not datatable. Could you please suggest. Also we are in 7.4.2 version, could you please suggest if we have an option for sending automated mail through kibana in any specific version of kibana. ---
**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:** [August 18, 2020, 1:49pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/4 "2020-08-18T13:49:55Z")
> When we checked Canvas, we could only see download format as pdf but not datatable. Do you mean you can't export it as a CSV file? This is indeed not possible at the moment, but you can export the whole canvas sheet as PDF. This PDF will include the same information in a more readable form (also possible to automatically schedule this to send it via mail): ![Screenshot 2020-08-18 at 15.47.41](https://us1.discourse-cdn.com/elastic/original/3X/0/e/0e3398e63763f3d93d4dbe7f869a66a20ea675d6.png) ---
**Author:** ![Ramadevi](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Ramadevi](https://discuss.elastic.co/u/Ramadevi)\ **Post date:** [August 18, 2020, 1:55pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/5 "2020-08-18T13:55:41Z")
Could you please suggest procedure for this - also possible to automatically schedule this to send it via mail ---
**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:** [August 18, 2020, 1:58pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/6 "2020-08-18T13:58:09Z")
Check out [https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html), it describes your use case ---
**Author:** ![Ramadevi](https://avatars.discourse-cdn.com/v4/letter/r/0ea827/32.png) [@Ramadevi](https://discuss.elastic.co/u/Ramadevi)\ **Post date:** [August 18, 2020, 3:50pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/7 "2020-08-18T15:50:02Z")
Query 1: We dont have Reporting/Watcher in version we are using.Actually we just have kibana url(7.4.2).How can we get reporting/watcher.Should we get latest version. 1. We tried to download json format for table, but after download we could notice we are getting only sql query but not tabular data ```auto { "css": ".canvasPage {\n\n}", "id": "workpad-80dc2782-0eba-476b-9056-f6c1db412469", "name": "Untitled Workpad", "width": 1080, "height": 720, "page": 0, "pages": [ { "id": "page-76b9e017-7a80-45c6-a92f-ba8d7823d76d", "style": { "background": "#FFF" }, "transition": { }, "elements": [ { "id": "element-04f9513a-0e94-4ae9-b7c7-4bd4c2367e46", "position": { "left": 20, "top": 20, "width": 500, "height": 300, "angle": 0 }, "expression": "filters\n| essql query=\"SELECT * FROM \\\"rmp_*\\\"\"\n| table\n| render" } ], "groups": [ ] } ], "colors": [ "#37988d", "#c19628", "#b83c6f", "#3f9939", "#1785b0", "#ca5f35", "#45bdb0", "#f2bc33", "#e74b8b", "#4fbf48", "#1ea6dc", "#fd7643", "#72cec3", "#f5cc5d", "#ec77a8", "#7acf74", "#4cbce4", "#fd986f", "#a1ded7", "#f8dd91", "#f2a4c5", "#a6dfa2", "#86d2ed", "#fdba9f", "#000000", "#444444", "#777777", "#BBBBBB", "#FFFFFF", "rgba(255,255,255,0)" ], "isWriteable": true, "assets": { }, "@timestamp": "2020-08-18T15:33:29.898Z", "@created": "2020-08-18T15:32:54.943Z" } ``` 3.Is there a possibility to invoke kibana url to download tabular data from canvas ---
**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:** [August 18, 2020, 3:52pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/8 "2020-08-18T15:52:31Z")
No, there is no way to do this. Reporting and watcher are under the gold license, so you need a subscription for this: [https://www.elastic.co/subscriptions](https://www.elastic.co/subscriptions) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 15, 2020, 3:52pm UTC](https://discuss.elastic.co/t/percentage-calculation-in-kibana/245090/9 "2020-09-15T15:52:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.