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?