Skip to main content
Question

Count #of unique activities per variant

  • August 3, 2020
  • 1 reply
  • 3 views
mehdi.bouga
Level 2

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

1 reply

V
Level 0
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
Community Code of ConductAccessibility statement