Hello, I would like to implement a โStreakโ feature in my app. The app lets users record time entries, and Iโd like to be able show them that theyโve recorded an entry for 5 days in a row for example. I have a table for โEntriesโ with a Date column. The actual computed streak would live in another โMetricsโ table โ each entry type is associated with a โMetricโ row.
I know that once I have the first day of the streak, I can use a subtraction to get a duration from today and figure it out from there. But I donโt know how Iโd compute the first day of the streak.
I can think of how code for it might work; start with today and โwalk backโ a day at a time until we find the first day where there isnโt an event. Sound tricky to implement this in a formula expression thoughโฆ
Any help would be appreciated!
LinkedIn
Twitter
