I have a basic set of data like the below with a date field and a score 02/01/2019 3 02/01/2019 4 03/01/2019 2 03/01/2019 4 03/01/2019 3 03/01/2019 2 04/01 2019 5 04/01 2019 5
Looking to have a counter for our scoring system, on scores consecutively greater than 2 count up, once a score less than 1 is entered for the counter to thne reset to 0.
Does anyone have any ideas on how this could be done
I am not really understand the requirement. Perhaps this? Else please provide expected result as well
Count({<Score={">=1<=2"}>} Score)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful