3 Replies Latest reply on Dec 6, 2018 12:17 AM by Amit Narkar

    Average count distinct of count distinct

    Esuri Ency

      Hello, newbie trying to understand aggregates and LOD calculations. See attached workbook (2018.3)

      I have IDs and Sub IDs. I want to see the number of unique IDs, unique Sub IDs, and then an average Unique Sub ID per Unique ID by Category. I cannot figure out how the calc should be structured.

         

      AppleOrange
      # of Unique IDs43
      # of Unique Sub IDs32
      Avg Unique Sub ID per Unique ID11.67