Unable to create a KPI metric

[abinaya.sundaram]

I have created a dashboard, where i have applied a filter to get a count based on a criteria and i wanted to calculate the KPI in percentage based on the filter result Thanks in advance.

[sudster]

Hi @abinaya.sundaram , welcome to the community!

I’m guessing you are talking about a dashboard created in Excel? If that’s the case, I am not too sure where does UiPath come into the equation, as Excel is more than capable to calculate KPI % based on filters. Or, maybe there’s more to the story; if that’s the case please post an example.

[abinaya.sundaram]

Apologize for the miscommunication happened. I have created the dashboard in UiPath Process mining where i wanted to create a filter to get a count based on criteria and i wanted to calculation to be percentage.

Thanks in advance.

[ankit.saraf]

@abinaya.sundaram - I am assuming you are using the KPI Editor and want to show a percentage of the filtered data vs the total set.

You can do that in the following fashion -

1. First create a Count node for the property that you want to use
2. Set the filters on the node you have just created
3. Add another node for Count for the same property
4. Set the operator are division for the calculation
5. Enable the display as percentage radio

This screenshot is a sample of how this will look once you set it all up -