Counting Distinct Cases with a Set Analysis of Counting differing fields less than or equal to
Firstly thanks for all the great help and support in this group.
I have Cases with have 1 to many Work orders which in turn have 1 to Many Work Order Lines
There may be multiple engineer visits on a Work Order Line. The challenge is to count all Distinct Cases where there have been one or less days of work.
The above data would thus resolve to 7 Distinct Cases and 5 of them where 1 or less work days are evident. So Case 0114682262 would not be counted as work took place over 2 days, the 13th and 14th but 0114704373 would be counted as all work was completed in one calendar day.
So how do I write an expression with Set Analysis to count distinct cases for 1 or less work days.
The solution will be used in a Straight Table and a Text field.