8 Replies Latest reply: Oct 17, 2012 1:06 PM by giovangabriele RSS

    problem with daily and accumulated events

      Hi all,

      I've the following scenario I am not able to solve.

      In my document I've a table activations that stores (unique_id, dateActivation, dealer) and a table first_activations that stores (another_unique_id, dateFirstActivation, dealer).

      What I'd like to show on a chart is, for each day, the total # of activations made in a day divided by the unique dealers that since the beginning of the service made at least one activation.

      If I make a count(unique_id)/count(dealer) I obtain the data of activations divide unique dealers of the day which is not what i need

       

      Do you have any tip on how i can aggregate the unique dealers? I'd like to make something like count(unique_id)/count(dealers<since beginning>)

       

      thanks,

      g