CODEWITHSUNDEEP
kibanaelasticsearch-painless
Mg Mogaki
Mg Mogaki

Reputation: 113

Kibana Painless Scripted Fields

I'm new to Kibana. I've been tasked with replicating an excel report into a dashboard.

I want to use a data table to display my values and also have a calculated field for percentages. The percentiles metric is not what I am trying to use to perform my calculations.

In the excel report the percentages are calculated using a formula like this : =I20/$I$28*100

It's a relatively simple formula I want to replicate in Kibana. Is there a way to create a scripted field in Painless or is there an even easier way to do this?

Some assistance would be much appreciated.

Thanks in advance.

Upvotes: 1

Views: 467

Answers (1)

Mg Mogaki
Mg Mogaki

Reputation: 113

Figured it out.

return 100 * doc['SD_TOTAL'].value / 81857

Upvotes: 1

Related Questions