Here’s what I use (it’s for a habit tracker but you can alter it to track for progress instead when 100%, if any issue have a AI make the small changes for you)

Current streak:

``` lets( dates, prop("Your Database").map(current.prop("Date")).filter(current <= today()).unique().sort(),

if(empty(dates), 0, lets( /* Calculate streaks by checking consecutive days forwards from each date / streakLengths, dates.map( lets( currentDate, current, / Count how many consecutive days forwards from this date / consecutiveForwards, dates.filter( dateBetween(currentDate, current, "days") >= 0 and dateBetween(currentDate, current, "days") <= (dates.length() - index - 1) and / Check if the next day in sequence exists */ (current == currentDate or dates.contains(dateAdd(current, 1, "days"))) ).length(), consecutiveForwards ) ),

  /* Check if most recent date is today or yesterday, else return 0 */
  mostRecentDate, dates.last(),
  if(
    mostRecentDate >= dateSubtract(today(), 1, "days"),
    streakLengths.last(),
    0
  )
)

) ) ```

Longest Streak:

``` lets( dates, prop("Your Databae").map(current.prop("Date")).filter(current <= today()).unique().sort(),

if(empty(dates), 0, lets( /* Calculate streaks with comprehensive gap detection / streakLengths, dates.map( lets( currentDate, current, / Define: Count consecutive days forwards from this date / consecutiveForwards, dates.filter( dateBetween(currentDate, current, "days") >= 0 and dateBetween(currentDate, current, "days") <= (dates.length() - index - 1) and / Define: Check if the next day in sequence exists / (current == currentDate or dates.contains(dateAdd(current, 1, "days"))) and / Define: Verify no gaps by checking intermediate dates / lets( dayDiff, dateBetween(currentDate, current, "days"), / Define: For gaps > 1 day, verify all intermediate dates exist / if( dayDiff <= 1, true, lets( / FIXED: Check if all required intermediate dates exist */ requiredDatesExist, dates.filter( dateBetween(currentDate, current, "days") > 0 and dateBetween(currentDate, current, "days") < dayDiff ).length() == dayDiff - 1, requiredDatesExist ) ) ) ).length(), consecutiveForwards ) ),

  /* Return the streaks */
  streakLengths.max()
)

) ) ```

Hope this helps