Filter variant explorer by activity

Hello,

I am trying to filter a variant explorer by activity and not by case.
I want to hide certain activities from the filter, but without doing it manually from the hidden activities dropdown, so that I can assign a variable to it and change it dynamically.
Is there any way to do this?

Many thanks

Hi @Ale,

you could define a custom dimension. The custom dimension can be defined as follows:

CASE
WHEN “Activity Table”.“Activity Column” IN (<%= Variable %>)
THEN NULL
ELSE “Activity Table”.“Activity Column”
END

The custom dimension can be defined in the component settings of the variant explorer.
In case you need support on how to define the variable, feel free to reach out to us again.

Hopefully, that’ll solve ysour issue!

Best regards,

Justin