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