Hi guys, Im trying to trigger an event when my To-Do has all task compleated.
I got this table call TODO
ID TASK Finished? (yes/no)
I got the event on UPDATES only
with the following condition:
Count
(
FILTER(
TODO, [FINISHED?] = False
)
) = 0
This actually works pretty well but Iโm concerned about performance on big data.
My question is:
THANKS!
Solved! Go to Solution.
I would not consider 2000 records to be very big.
I believe the following would also work, and probably would be more performant. But really, thatโs not an expensive expression to start with.
ISBLANK( TODO[Finished?] - LIST( TRUE ) )
How big are you thinking?
It is actually part of a Multi User App.
So it may go up to 100-200 users.
Each user may have like 20 Tasks
So the TODO table may go up to 2000 Registers, Filtered with a Security Filter.
I would not consider 2000 records to be very big.
I believe the following would also work, and probably would be more performant. But really, thatโs not an expensive expression to start with.
ISBLANK( TODO[Finished?] - LIST( TRUE ) )
Awesome!
I was not aware of lists could substract in that way. Another time, Jumping stairs without knowing the basics delays everything. Thanks for the solution
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |