Using formula section on the vertical axis

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.


Can you write formula on a scripted field?

You can use this formula

count() / overall_sum(count())

Overall functions were introduced in 7.14

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

1 Like

Thanks a lot!

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.