1 Reply Latest reply on Nov 5, 2018 1:27 PM by Hari Ankem

    Calculate Distinct Counts for Measure Value

    chakradhar kakani

      Hello Tableau users, i'm going through a Use case Scenario Where I want to calculate Distinct Count for a Measure Value, for example in below Original Data Set I have two columns Cust ID and Type we can Calculate Distinct Count i.e. there are 6 Distinct Customers, in my below Explanation Table below Acct 4 was exposed 1 Time, Acct 2 was exposed 2 times, Acct 1 was 3 times and Acct 5 & 6 was exposed 5 times,

      so my use case is I want to Calculate the number of Times Exposed as Dimension and Calculate the Distinct Counts of Customer ID's that were exposed so many N times which is Expected Output Table from the Original Data Set Below Can somebody please help me in this would appreciate it. I have attached an WB

       

      Original Data Set

       

      Cust IDType
      Acct 1Exposed
      Acct 1Exposed
      Acct 1Exposed
      Acct 2Exposed
      Acct 2Exposed
      Acct 3Exposed
      Acct 3Exposed
      Acct 3Exposed
      Acct 3Exposed
      Acct 4Exposed
      Acct 5Exposed
      Acct 5Exposed
      Acct 5Exposed
      Acct 5Exposed
      Acct 5Exposed
      Acct 6Exposed
      Acct 6Exposed
      Acct 6Exposed
      Acct 6Exposed
      Acct 6Exposed

       

      Explanation Table

       

      Number of times ExposedCust ID
      1Acct 4
      2Acct 2
      3Acct 1
      5

      Acct 5, Acct 6

       

      Output Expected In Tableau

       

      Number of times ExposedDistinct Count of Cust ID
      11
      21
      31
      52