Task to count number of entries per user over a shift - with slight twist

[roattw]

Scenerio:  We have people that take 12-24hr shifts and are on call.  During those shifts they average  8 call, each of which they need to log as an entry in our DB.  These people are really busy (physicians) and we are pretty sure some arent entering all thier calls.  Hoping to generate a task report counting all the entries a person makes per shift and for all shifts over a 2 weeks period.  Knowing 8 is an average, we would like to flag and shifts where there were <5 to serve as a flag to cotact the user to make sure they entered all thier cases.

The date looks like over a couple days:

MD_ID           Entry_ID           Name                   Date

22                         250                  Smith                  8/6/25
22                         251                  Smith                  8/6/25
22                         250                  Smith                  8/6/25
22                         250                  Smith                  8/6/25
22                         250                  Smith                  8/6/25

 

 

[NiceDuck]

The only notable difference I see on this one compared to this: 

is the 2 weeks period.

In that case, we just need to apply a filter on the same task so that it would only include records starting from 2 weeks ago.

Use the same Task here: 

But apply this adjustments:

[NiceDuck]

OH! and adjust the conditional statement for the flag as well from 6 to 8.

I hope this helps!