11 Replies Latest reply on Sep 14, 2018 11:36 AM by Daniel Segura

    How to Build a 'Two Consecutive Weeks' Aggregation with Calculated Field

    Daniel Segura

      Hi all,


      Does anyone know how I can aggregate data by two consecutive weeks? I'm not sure if I'm expressing myself correctly. This is what I would like to see:


      Let's say I have profit data by week:


      But I want to see it like this:


      How would you guys write the calculated field?


      Thank you so much,


      Daniel S.