Finding count of course completed user for current(Latest) campaigns of particular Batch.

[berryandcherry6]

My requirement is to find count of user who have completed course(final_test_status={'passed'})  in for particular batches or client id.Each client may have some batches(Usually 3 to 5).  Each batch may have several campaigns.Every current batch contains 3 campaigns.so How could i find user course completed for latest 3 campaigns.

Currently i am using this code,

sum({$<CanonicalDate={">=$(=date(max(weekstart)))<=$(=date(max(WeekEnd)))"},

DateType= {'completion'},client_name = {'Enova'},final_test_status={'passed'}>} course_completed)

But this giving wrong count ,as user might completed course at 12 night,so it gets added to next campaign.as every campaign starts from tues to sunday.

so i need to do other work around.

I have attached csv files.Please help me in this regard.Any idea or suggestion is very helpful.Please feel free to share knowledge.

Thanks,

Supriya