You are reading a single comment by @rhb and its replies. Click here to read the full conversation.
  • I have a sheet with 10k+ rows, each one is a date stamped visit by a customer (uid) to one of 11 session types, some of which are attended sequentially, but not necessarily so.

    e.g.

    Customer | Session Type | Date | other fields

    I've been asked to calculate the average duration from 1st to 4th of the sequential session types, for those customers who've done this.

    Using Pivot I can show Min Date and Max Date per customer for these session types, but can't exclude those who only did 1st but not 4th (or 4th but not 1st as their first happened before this set of data).

    This is where I get stuck.

    Anything simple I'm overlooking?

About

Avatar for rhb @rhb started