Skip to main content
Question

Cropping the Process Explorer using a component filter

  • November 13, 2023
  • 4 replies
  • 48 views

Forum|alt.badge.img+14

The Process Explorer can have its activities cropped via use of the Crop Selection page filter, however when using the formulas CALC_CROP and CALC_CROP_TO_NULL in its component filter, the Process Explorer fails to crop

 

Can the Process Explorer be cropped via component filter? If yes, what is the correct formula / way to do this?

4 replies

emiel.van.n14
Level 4
Forum|alt.badge.img+14
  • Level 4
  • 9 replies
  • November 14, 2023

Hi Josh,

I would suggest to use Filters (on component level if using process explorer as a component otherwise on sheet or analysis level).

perhaps these links can be of help >> Link 1 and Link 2

 

 


Forum|alt.badge.img+14
  • Author
  • Level 1
  • 2 replies
  • November 15, 2023

Hi Emiel,

 

Thanks! Used the following formula as a custom dimension in the process explorer:

 

CALC_CROP_TO_NULL ( FIRST_OCCURRENCE ['Activity1' ] TO LAST_OCCURRENCE ['Activity2] , "Activity Table"."Column Activity")

 

Then converted it to a variable (i.e., <%=variable%>) so it could be used within a button dropdown where the Set Variable is chosen as a Button action, that way depending on the button dropdown selection, the formula updates with different activities to crop the process explorer in a different way.

 

Regards,

Josh

 


magdalena.silak11
Level 3
Forum|alt.badge.img

Hi Josh,

 

were you able to do it as a component filter? I am currently facing this issue.

 

BR,

Magda


Poovarasan
Level 1
  • Level 1
  • 2 replies
  • April 2, 2025

Hi Josh,
I am also trying to Apply a Component Filter to the Process Explorer, so that it can only show specific activities. I have already tried with several formulas but nothing seems to be working. can you share me any pql statement which i could use for this case.
 

Thank you