This content has been marked as final. Show 3 replies
You can do this in a chart or straight table using the JobID as dimension, and the expression:
Sum(Aggr(Sum(If(KeyDate >= JobStart And KeyDate <= JobEnd, WorkingHours)), JobID, KeyDate))
See example attached.
Hope that helps
Test.qvw 141.2 K