Skip to main content
Question

Cropping the Process Explorer using a component filter

  • November 13, 2023
  • 2 replies
  • 0 views
A
  • Anonymous

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?

2 replies

A
  • Anonymous
  • 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

 

 

A
  • Anonymous
  • 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

 

Terms & ConditionsAccessibility statement