Need help counting Curent Streak and Longest Streak

Ask for Help
9

Okay, I’ll try to explain in a bit more detail.

  • Start with a Query column in your Users Table that targets the Trips table, and apply the following:
    – Filter: User is This row->User
    – Order by: Trip Date (descending order)
  • Use a Single Value column to get the first Trip Date from the Query column (this should give you the Date of their most recent Trip)
  • Use a Single Value column to get the first StreakBasedOnRowDate from the Query column (this should give you the value of their streak after their most recent trip)
  • Calculate the number of days since their most recent Trip: Trunc(Now-LastTripDate)
  • Add this to the Streak value as it was after their last Trip (value obtained above)
  • And the result of that should be their current Streak.
2 Likes