9 Replies Latest reply on Jan 9, 2018 6:26 PM by parul bansal

    Rolling median - income over months

    Soumya Tejas

      This is where I am right now:

      Since the cycle starts from Oct, the months are placed in this sequence. Right now the graph tells me median for income corresponding to data of that particular month only.

       

      Goal - To get median of income for data of current month and all months prior to it, in sequence as mentioned above.

       

      I did go through some discussions, suggesting offsets and window_median.. but am unable to wrap my head around it for this solution. Any help/suggestion will be really appreciated. Thanks!