6 Replies Latest reply on Jan 20, 2014 12:14 AM by Vaida Lauzeckas

    Median calculation in transaction data

    Vaida Lauzeckas

      Hi everyone,

      I am hardly stuck trying to accomplish one calculation. I have transaction data of purchases like this:

      User_id, Date

      45, 2012.11.27

      2000,2012.12.27

      45,2012.12.18

      ....

       

      I am trying to group each customer by median of days between its purchase dates. I managed to calculate easily median for each customer but have difficulties in grouping them: 

      Problem.jpg

      Any suggestion how to make this bar normal and display that there is 3 users having median = 6?

       

      V.