Using formula section on the vertical axis

[behappy_alwayz0401 (kibanauser0401)]

Hi,
I want to show the count as a percentage. Currently it is displaying the count of files. How do I show the count as a percentage of the total number of files in the formula section of the vertical axis. attached screenshot.

thanks

[behappy_alwayz0401 (kibanauser0401)]

Can you write formula on a scripted field?

[Stratoula_Kalafateli]

You can use this formula

count() / overall_sum(count())

Overall functions were introduced in 7.14 https://github.com/elastic/kibana/pull/99461

You can change the value format to percent if you want to have the axis to a percent format

Scripted fields support math calculations but not formula as it is in Lens

[behappy_alwayz0401 (kibanauser0401)]

Thanks a lot!