You could just have an association between the two or more entities and then use conditional display logic in the data view to show the attributes you are interested in.
Hi – in this case, I need to sum some fields and then divide the sums by user. So I’m thinking OQL is my best bet?
I created OQL recently and able to run report.
Below is the example of Query…
select
INVITE.InviteCode AS InviteCode,
INVITE.CustomerEmail AS CustomerEmail
CUSTOMER.CompanyName As CompanyName
FROM ABC_Customer.Invite INVITE
LEFT OUTER JOIN INVITE/ABC_Customer.Invite_CustomerAccount/ABC_Customer.CustomerAccount AS CUSTOMER
where 1=1
and ( INVITE.DateSent>=(Select max(Reporting.ReportSearch.InviteCreationStartDate)
from Reporting.ReportSearch where Reporting.ReportSearch/Reporting.ReportSearch_User='[%CurrentUser%]'
) or (Select max(Reporting.ReportSearch.InviteCreationStartDate)
from Reporting.ReportSearch)=NULL )