Skip to main content
Question

I created a custom "Process Explorer" KPI to show % ie Activity Count over Total Activity Count. This works fine when there are no selections made on initial launch of but when there is a selection made on a OLAP table the KPI goes blank. Please

  • August 19, 2022
  • 3 replies
  • 24 views
.
Level 1
I created a custom "Process Explorer" KPI to show % ie Activity Count over Total Activity Count. This works fine when there are no selections made on initial launch of but when there is a selection made on a OLAP table the KPI goes blank. Please advice.

    3 replies

    gabriel.okaba11
    Celonaut
    Forum|alt.badge.img+2

    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.

     

    Gabe
    .
    Level 1
    • .146015048
    • Author
    • Level 1
    • August 22, 2022

    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.

    D
    Level 0
    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!
    Community Code of ConductAccessibility statement