Elastic metric count to percentage

[Prathamesh_S_Pai]

I am using metric visualization type in kibana. In Metric section, I have used 'count' aggregation and in bucket section, i have used 'terms' aggregation with field 'executionStatus.keyword' and clicked on 'update' button. The output shows '154 Executed-Count' and '4 Not Executed-Count'.

How to show this in percentage? I want the output to be '97.47% Executed-Count' and 2.53% Not Executed-Count'

[nickpeihl]

Hi @Prathamesh_S_Pai. I think you could use a custom formula in Lens to calculate the percentages. For example, count() / overall_sum(count()). You'll also want to change the "Value format" to "Percent".

[Prathamesh_S_Pai]

Hi @nickpeihl,
Thank you for your response.
Since I am using metric visualization type, I not seeing any formula tab either in Data or in Options section.

Could you please let me know how to convert those count to percentage?

[nickpeihl]

Hi @Prathamesh_S_Pai. Which version of Kibana are you using? The formula editor is only available in our Lens visualization editor. Your screenshots are showing an older, legacy visualization editor which does not support formulas.