CMS Designer Reports CMS Release 16.2

[wokdabat]

I am trying to build a designer report using the two table names, haglog and dagent using inputs Agent Group and Date. I am able to get these two table names working together in a single table in Designer, but I would like a single row for each agent. If an agent logs into multiple skills I get a row for each. I am doing the min(login) and max(logout) to limit those rows, but the report still gives me two rows because of ACD calls taken on multiple skills.

To further messy the waters when I do a sum(dagent.ACDCALLS) it is adding those per row, so if an agent logged in and out 4 times in one day and took 3 calls I get 12 as the total. This is to be expected based on the calculation but how can I just get dagent.ACDCALLS which is just 3. Also, the report actually runs correctly as long as the agent logs in and out one time.

Can someone help me with a calculation I need or how the where clause should look?

PS, I do have this working with two tables side-by-side in one designer report, but was aiming for one table.

Thanks,

Joaquin