Show the number of logins and the number of incidents at the same report
Summary
number of logins and incidents at the same reportContent
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
Tagged:
0