3 Replies Latest reply on Jul 17, 2018 10:21 AM by Nic G

    Best way to calculate this ? (I'm going Bonkers)

    Nic G

      I'd like to get a distinct count of the date for each different client, and then divide the data by that distinct count....

       

      eg.

        

      01/07/2018a_client100
      02/07/2018a_client89
      03/07/2018a_client5
      04/07/2018a_client44
      05/07/2018a_client55
      06/07/2018a_client85
      07/07/2018a_client42
      08/07/2018a_client1
      09/07/2018a_client77

       

      For a_client we see 9 unique dates, so first row would be 100/9 = 11.11

       

      and then so one for each client (bare in mind the # of dates will be different for each client).

       

      I'm struggling to to get either a distinct row count or date count in the first instance :-(

       

      Appreciate anyone's help, pretty please :-)

       

      Nicky x