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?
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
Hi Emiel,
Thanks! Used the following formula as a custom dimension in the process explorer:
CALC_CROP_TO_NULL ( FIRST_OCCURRENCE E'Activity1' ] TO LAST_OCCURRENCE E'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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
