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.