1 2 Previous Next 16 Replies Latest reply on Feb 26, 2016 3:05 PM by Carlos Flores

    Getting a sum of weekly count distinct? Cant seem to do it

    Carlos Flores

      I want to get a total count of Count Distinct based on a weekly pull.

      If i do a basic count distinct, ill get only the distinct values for the whole time period. I want to break down the value by week then add it, can anyone help me out?

       

      Ideally i want to get that 3,353 value and do some calculations to it, but the only way to get it is to break down the count by week and add a grand total.

       

      Any ideas?!

        1 2 Previous Next