# Kibana 7.5 Data Table percentage using Json input
**URL:** https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740
**Category:** Kibana
**Created:** [February 4, 2020, 8:20am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740 "2020-02-04T08:20:07Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@umay\_fb](https://discuss.elastic.co/u/umay_fb)
#### Post date: [February 4, 2020, 8:20am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/1 "2020-02-04T08:20:07Z")
I have problem, i have data and i want make kibana data Table like this, but i want create percentage beside each Col. like percentage DLV H-1, can i make it with Json input?
i create Json input like
{ "script" : "doc['DLV H-0'].value \* 100 / doc['Total Resi'].value" }
but its not run, give me advice... Thanks before
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [February 4, 2020, 6:30pm UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/2 "2020-02-04T18:30:30Z")
JSON input will not work over aggregated data.
The data table now supports adding a [percent column over a metric](https://github.com/elastic/kibana/pull/39572) starting in 7.4.0. But I can not tell from your example if that will help. Is it possible to split the DLV\* totals into separate rows in your data table?
---
### Author:  [@umay\_fb](https://discuss.elastic.co/u/umay_fb)
#### Post date: [February 5, 2020, 8:18am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/3 "2020-02-05T08:18:31Z")
can we add more than 1 percent column over metric? I see its only can add 1 percent column. for the split row icant cause i will use split column to split data by regional, city and partner. it can use alot of bucket right?
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [February 6, 2020, 1:13am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/4 "2020-02-06T01:13:59Z")
Can you show me how you configured your data table? Maybe with a screenshot and blur out any sensitive data.
It may be possible to add percentage columns in a table in TSVB using a Bucket Script aggregation.
---
### Author:  [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [February 10, 2020, 7:08am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/5 "2020-02-10T07:08:56Z")
Use the plugin \>\>Enhanced table. using this you can achieve this.
Thank you!
---
### Author:  [@umay\_fb](https://discuss.elastic.co/u/umay_fb)
#### Post date: [February 10, 2020, 10:18am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/6 "2020-02-10T10:18:20Z")
thnks , how to use the plugin?? sorry i am new in kibana...
---
### Author:  [@balaji\_18](https://discuss.elastic.co/u/balaji_18)
#### Post date: [February 10, 2020, 10:24am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/7 "2020-02-10T10:24:30Z")
use this link to download :[https://github.com/fbaligand/kibana-enhanced-table](https://github.com/fbaligand/kibana-enhanced-table)
After downloading use below steps to install
Every release package includes a Plugin version (X.Y.Z) and a Kibana version (A.B.C).
- Go to [releases](https://github.com/fbaligand/kibana-enhanced-table/releases) and choose the right one for your Kibana
- launch a shell terminal and go to $KIBANA\_HOME/bin folder
- use Kibana CLI to install :
- directly from Internet URL : `$KIBANA_HOME/bin/kibana-plugin install https://github.com/fbaligand/kibana-enhanced-table/releases/download/vX.Y.Z/enhanced-table-X.Y.Z_A.B.C.zip`
- locally after manual download : `$KIBANA_HOME/bin/kibana-plugin install file:///path/to/enhanced-table-X.Y.Z_A.B.C.zip`
- restart Kibana
---
### Author:  [@umay\_fb](https://discuss.elastic.co/u/umay_fb)
#### Post date: [February 11, 2020, 7:51am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/8 "2020-02-11T07:51:27Z")
thnks @balaji_18
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 10, 2020, 7:51am UTC](https://discuss.elastic.co/t/kibana-7-5-data-table-percentage-using-json-input/217740/9 "2020-03-10T07:51:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.