Show the number of logins and the number of incidents at the same report

Summary

number of logins and incidents at the same report

Content

Hi all,

I am trying to display below information in the same page:

Account name, number of logins, number of open incidents

For this, I was using three tables - Accounts, User_trans, Incidents

(Accounts.acct_id = User_trans.acct_id, Accounts.acct_id = incidents.assgn_acct_id)

The problem is this condition has a result of [number of logins * number of open incidents] due to the join condition. Probably, I need a some sort of UNION ALL function to get the correct value.

 

In the report, I've set