With several records completed per day, I should like to see which number in a row the completed record is. Each record has a โCompleteโ status and a โTimeCompletedโ DateTime.
How can I construct an expression to see which number in a row each record is for the day it was completed?
What do you mean with โโฆwhich numberโฆโ? Do you want to count the total number of records with โCompleteโ status?
@LeventK - during a day I will complete several actions. The first action is #1, the next #2 and #3 and so on. Next days we start with #1 again.
Perhaps:
MAX(
SELECT( table[number] ,
AND(
[Complete] ,
DATE([TimeCompleted]) = TODAY()
)
)
)
+ 1
This expression should set the value of the [number] column when a record is marked as completed (perhaps as an Initial value with an appropriate resetOnEdit expression, or an Action).
This assumes that all records are marked as completed on the day that they are completed.
This also assigns the values in the order in which they are marked completed in the app, disregarding if any of the time completed values arenโt in temporal order (that would be a lot more complicated/expensive).
I would go about creating a slice to hold this subset of data;
โTodays_Completed_Itemsโ or something
and(
[Status] = "Complete',
DATE([Completion_Timestamp]) = TODAY()
)
Then, when the record is marked as complete:
COUNT(Todays_Completed_Items[ItemID]) + 1
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |