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





      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: 


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