Show the number of logins and the number of incidents at the same report
Summarynumber of logins and incidents at the same report
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