3 Replies Latest reply on Jul 19, 2019 1:15 PM by Yuriy Fal

    Count Volume of Events Since a Particular Event

    Martyn Phillips

      Hi,

       

      I was trying to understand how I would create a calculated field that will tell me how many shots a player has taken since their last goal.

       

      In 'sheet1' I want to count 'outcome' since 'outcome' was 'goal' - I don't have a clue where to start or how to express this using a calculated field, or even if it can be done, though I have seen similar things done with time since an event occurred.

       

      I'm hoping this makes sense, and someone has an easy to understand answer?

       

      I have attached my workbook. Any advice is welcome

       

      Thanks

      Martyn