Can you share the PQL formula? If you want to make an overall' KPI - unselect the checkbox "Component is not filtered with selections" on the KPI component, so it is not affected by the selections.

 

---

Can you share the PQL formula? If you want to make an overall' KPI - unselect the checkbox "Component is not filtered with selections" on the KPI component, so it is not affected by the selections.

 

Thank You for your response.

I'm using the below

COUNT_TABLE ( "_case_details" )/global(COUNT_TABLE ( "_case_details" )).

We are looking for the process explorer to be filtered by global filters and still have process explorer KPI to function at the same time and see the % values on all nodes. Currently the % values go blank for the nodes not associated with global filters but otherwise look good.

---

Hi there, just looking at your PQL, if the case detail table is your case table, what this actually appears to be measuring is the percent of cases that flow through a given activity, rather than the percentage an activity occurs compared to all other activities. Was this your desired KPI or did you want % activities rather than % cases? Furthermore, is it possible that your global filters are removing any occurrences of the activities which are getting blank values? This is often what causes something such as this. For example, if you filter on a specific supplier and no order using that supplier has ever had the activity cancel goods, then your kpi for that activity node will become null. Let us know if you have any further inquires!

---