3 Replies Latest reply on Feb 19, 2018 10:49 PM by Rachel Chacko

    sum of the last x no. of months



      Hi, I was trying to sum up the "yes" and "no" separately for the past 6 months.  I've tried using window_sum to total the last 6 rows. But I want 6 months' worth of "yes" and 6 months' of "No".  it's not predictable because sometimes either Yes" or "No" is not there.  Eg July 2017 has a "Yes" but "no" is missing.


      Does anyone have any tip?


      Thanks, Sea Urchin