2 Replies Latest reply on Feb 28, 2018 5:41 AM by Onna s

    Count only the first occurrence over time

    Onna s

      In the data set below, how can I count only the first occurrence of color over the Sequence (string dimension).

      For example, although through each sequence color Red for ID 1 changes to Blue I should count this as Red (whatever value the first occurrence has)

      Below is how the final counts should look like:

      I am attaching a starter workbook.

       

      Thank you for your help!