6 Replies Latest reply on Jun 20, 2019 9:37 AM by Ken Flerlage

    Find the year a value first occurs

    Stephen Campbell

      Hi,

       

      I'm struggling to come up with a calculate field to determine the first time a "1" appears in the second column for each country listed in the first column. Where would I begin? I'm assuming I'd need to segment by country, but I don't know how.

      Screen Shot 2019-06-16 at 9.56.14 AM.png