Option to show percentage

[bbhenry]

Instead of count, please add the option to show percentage especially for the pie chart.

[cfeio]

This would be a very useful feature.

[quentinchap]

+1

[garyelephant]

+1 for this

[rashidkpc]

I'm going to expand this to add percentages to anywhere it makes sense.

[rashidkpc]

#2785 would like to have this in metric agg too

• "% total" column in the table visualization
• "% total" values in the labels, especially for vertical bar and pie chart visualizations
• "% total" in a single-value widget

[monotek]

+1

[jettro]

+1, percentages would be very nice, maybe also stacked percentages:
I would like to create a table like this:

a     10  40%  40%
b      5  20%  60%
c      5  20%  80%
d      3  12%  92%
e      2   8%  100%

[pietrom]

+1!

[Fattybeej]

+1

[rafecolton]

+1

[antonKalinin]

+1

[pickworth]

+1

[markwalkom]

+1 (for me) and;
+1 for a customer :)

[srishaharidas]

+1

[yehosef]

+1

[shumkov]

+1

[novozhenets]

+1

[jonnybazookatone]

+1

[jomar83]

+1

[fredcido]

+1

[rajatjindal]

+1

[deepvoice]

+1

[dirkschneemann]

+1

[ajays1991]

+1

[GrahamHannington]

+1

My use case:

Each of my Elasticsearch documents represents a transaction. If a transaction "abended" (abnormally ended), the corresponding document contains an abend field; otherwise, the abend field is missing. The value of the abend field is a code that identifies the type of abend.

I want a metric ("one big number") visualization that shows the percentage of transactions that abended: that is, the percentage of documents where _existing_:abend is true.

[usercancel]

+1

[gitmich]

+1

[ppisljar]

i am closing this ticket as percentage mode is supported in:

• pie chart
• line, area, bar, horizontal bar
• metric, goal, gauge
• visual builder table (and other charts in visual builder)

please open a separate (more specific) issues for all the problems that are still there.

[Olummy]

@mseka1 can you please granularize the steps you took. I have created the scripted field but don't seem to have the same result as yours.

[agarwalshivam456]

@mseka1 I have created scripted field but it's not matching the field value and return 100% only unmatched value.

can you please help me out here.

[Olummy]

@agarwalshivam456 I had a similar experience after creating the scripted field. I couldn't bucket the values so all return 100%. @mseka1 please help out.

Thanks.

[mseka1]

i will help you guys @agarwalshivam456 @Olummy set up a zoom meeting email me the meeting id [email protected]

[arunkspkm]

@Olummy @agarwalshivam456
Try changing your scripted field format as Percentage. It works for me.

[Olummy]

Awesome... I will give this a trial. Many thanks

…

On Thu, Jun 7, 2018 at 12:04 PM Arunkumar S ***@***.***> wrote: @Olummy <https://github.com/Olummy> @agarwalshivam456 <https://github.com/agarwalshivam456> Try changing you scripted field format as Percentage. It works for me. [image: image] <https://user-images.githubusercontent.com/10754967/41095901-9b28d29a-6a70-11e8-8df0-5c0a18aba808.png> — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2284 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AMnHdTDhpCsZblshlh-bVX8apqqhiqaNks5t6QjQgaJpZM4DHlUx> .

-- *Olumide Michael Oyalola* *Data Science* m: (+234) 803 569 4053 a: s: t: l: 6.5536° N, 3.4006° E, Lagos, Nigeria olummyanucitee @IamOlumide <https://twitter.com/iamolumide> Olumide Michael Oyalola <https://ng.linkedin.com/in/olumide-michael-oyalola-9a522857>

[JZ-SmartThings]

Current enhancement is housed here: #19489

[sahroni61212]

@hanzohan , i want install plugin percent metric in kibana. but i use windows 7 in my PC.
can u help me? how to install this plugin in windows 7

[rafivp]

@mseka1 I might need your help.
I tried to create the scripted field but I haven't been able to effectively create the scripted field, do you detail the calculation when created it? I am a bit lost, every little help will do.

Thanks!

[poloxue]

+1

[poloxue]

I want a table like:

a 10 40%
b 5 20%
c 5 20%
d 3 12%
e 2 8%

[drakkhen]

Give up and use Splunk.

[burcube]

+1

[funbrain]

Give up and use Splunk.

Splunk is expensive...

[vinhngx]

+1

[RuBiNaLDo]

+1

[alamsyahho]

+1 i really need this feature as well

[jbellina]

I was able to accomplish this using the datasweet formula plugin, it’s worked out great for us. See the full list of plugins here:

https://github.com/robcowart/kibana_plugins_list

[ShellySingh1]

Hello,

I am new to Kibana. I am using Kibana 7.4. and I am unable to figure out a way to show percentage and count for my simple bar graph. I could independently show either the percentage or the count on the bar chart, but not both together.
There have been some ideas about scripted fields, but I wanted to ask if even now, with Kibana 7.4, that's the only option. If you know of simpler options, please share. If not, any guidance on scripted fields will be much appreciated too!.

Thanks

[minoru-nagasawa]

I solved by this plugin.
https://github.com/fbaligand/kibana-enhanced-table

It allow us to add the calculation columns like "col['Count'] / total['Count']" .

[JZ-SmartThings]

I think this was fixed/enhanced in 7.4... see this new feature in my screenshot... however, thanks for sharing that nice plugin @minoru-nagasawa!

[EllandeBarthelemy]

Magnifique !!! Le ven. 15 mai 2020 à 07:20, minoru-nagasawa <[email protected]> a écrit :

…

I solved by this plugin. https://github.com/fbaligand/kibana-enhanced-table It allow us to add the calculation columns like "col['Count'] / total['Count']" . — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#2284 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADCNXZZDKOMEGRRU4WMQDSDRRTGLDANCNFSM4AY6KUYQ> .

[minoru-nagasawa]

Thank you. Thanks to the image, I was able to find it.
@JZ-SmartThings

[JZ-SmartThings]

My pleasure @minoru-nagasawa --- I also truly appreciate your post because that percentage column is great but it's not enough for my needs, it's barely the beginning. I was trying to do more math and the plugin you suggested is very cool. I can't wait to try it... I may finally be able to predict/verify my power costs without my fancy Excel spreadsheet that I copy and paste Kibana data into. Here's an example below... and your suggestion gets me much closer to the long term desire I've had.

[yaseralimardany]

Kibana 7.9 does not support this yet. any idea?
I want a table like:
a 10 40%
b 5 20%
c 5 20%
d 3 12%
e 2 8%

[vk036968]

Is it possible to add a checkmark to display "local" (to the panel) percentages?


38.42% + 22.56% + 39.02% = 100%