Count #of unique activities per variant

Hello Everyone,

I would like to create a table that list all the variants and then for each variant calculate how many unique activity there is.

example,

Variant ¦ acitivity count

step1,step2,step3 ¦ 3
step1, step3 ¦ 2

thank you for your help.

regards

Hi Mehdi,

you can use the VARIANT functionality to achieve this:
Dimension:
VARIANT(ACITIVITIES_TABLE.ACTIVITY_EN")
KPI:
COUNT(ACITIVITIES_TABLE.ACTIVITY_EN")

Best regards,
Viana

1 Like