CALC_CROP Filter statement

Question

Hello!

I am trying to apply a filter script on a process explorer component. I do not want to use a selection.

filter CALC_CROP(first_OCCURRENCEC'Start'] to last_OCCURRENCEC'End'], "Activities"."Activity Name") = 1;

For some reason it does not apply the filter and crop accordingly. Is there something I am missing? ('Start' and 'End' are placeholders)

magdalena.pröbs · Answer

I guess the issue is that the process explorer uses VARIANT and this is not filtered if the input isn't filtered.

You could use a custom dimension like

CASE WHEN CALC_CROP(first_OCCURRENCE['Start'] to last_OCCURRENCE['End'], "Activities"."Activity Name") = 1 THEN "Activities"."Activity Name" END

Sign up