Hi All, I need help counting streaks in my app. I have a trips table and have columns for date, trip event etc. What i ciuld like to count is the number of days a driver has gone without incurring a trip event. I trip event would be a mild barking or mild excelleration for which points are deducted. …

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 colum…

So is it correct that the “other column” you mention above is for some sort like an event type? Like you have multiple types of event and a trip event is one of them?

Yes the other column is the trip event column that stores an event like Mild Braking or Mild Acceleration. A third column then stores the event deduction points. E.g Mild Braking is 4 Points deducted from their daily drive points of 60.

Something like this should do it for you: Create a Query column in your Trips table that targets the same table and has the following filters: – User is This Row → User – Date is after This Row → Date – Points Deducted is greater than 0 Add a Single Value column that takes the earliest date fro…

Thank you for the response Darren. I just need some clarity on what the numbers mean in the StreakBasedOnRowDate? If I have followed you correctly. This is the output. I am not sur ewhat it means exactly. Which number is the start of a new streak? Is this output indicating the longest streak? […

StreakBasedOnRowDate should be their streak as it would have been on the Date of that row. To get a Users longest streak, create a Query or Multiple Relation from the Users table that matches their email and/or UserID in both tables, then use a Rollup->Maximum of the StreakBasedOnCurrentDate. To …

Is this counting their daily streak or their trip streak? Meaning is it counting the number of days between a trip event or the number of trips between a trip event? [/quote]

[image] Darren_Murphy: To get the current streak for each Driver, you would use the value in the row that corresponds to their most recent Trip, and add that to the difference between the row date and the current date. I also do not know what you mean by the value in the row? Which value exac…

Ok, i believe it is working as expected. I made a change here as your instruction were to get the first trip date instead of the last trip date, meaning the date of the most recent trip. [Screenshot 2023-10-25 at 09.35.44] The results. I had an event on the 23 October 2023 so 2 days looks correct. …

[image] Guilio_Del_Fava: Ok, i believe it is working as expected. I made a change here as your instruction were to get the first trip date instead of the last trip date, meaning the date of the most recent trip. hmm, did you add the ordering to the Query column? I know that the Order By clau…

Need help counting Curent Streak and Longest Streak

Ask for Help

system Closed November 1, 2023, 8:30am 14

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Streaks on glide Ask for Help	5	718	June 2, 2023
🔥 Calculate Current and Longest Streaks! Community Resources tutorial	1	735	April 2, 2022
Calculate a "streak" Ask for Help	4	1003	December 27, 2020
🔥 User Streaks (Gamification) Community Resources tutorial	9	1058	July 12, 2025
Trying to Build a Current and Longest Streak – Need Help Finishing It Off! Ask for Help	0	25	August 2, 2025

Need help counting Curent Streak and Longest Streak

Related topics