Skip to main content

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

Reply