Streak Tracking

Topic Labels: Formulas
537 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve seen this asked a couple places on the forums, but I haven’t seen a response yet.

Looking for a way to track streaks for a habit tracking base I’m building.

As you can see from the screenshots, I’m using one table for habits, and one for days (called Log). I’m assuming the streak field (consecutive days done) would be on the habit table, but that it would likely have to be some kind of fancy rollup formula that references the Log table.

Any ideas on how to accomplish this?


1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Hey there Steve,

I took a look at this and tried replicating it in my Dev base, and there’s really no way that I can think of to have it track consecutive days. One thing you COULD do is track the minimum date, maximum date, and the number of days that that habit was completed. This won’t get you a streak but overall “compliance.”

For example, if your start date is 9/1 and the end date is 9/10, if you did Programming for 4 days, you’d be 40% (depending on how you do the date math, but you get the idea).

It’s not perfect, but might be a way to perform a similar function.

Hope that helps!