Left Outer Join equivalent
I'm very new to CRMOD but have spent some years doing SQL reporting. Here's what I'm trying to achieve:
I'm creating a dashboard of salespeople and their respective stats. They range from leads engaged to opportunities closed won. I'm trying to align all the names going across so that it is easier to read.
Example:
Leads Converted Pipeline (Opportunity) Closed Won
Joe Smith 20 2,000 1,000
Jane Doe 40 5,000 3,000
In SQL, I would write a left outer join with USER against LEAD and OPPORTUNITY. How do I achieve the same thing in CRMOD? Basically, I want to show all the users within a sales group regardless of if they have totals for leads or opportunities.
I'm creating a dashboard of salespeople and their respective stats. They range from leads engaged to opportunities closed won. I'm trying to align all the names going across so that it is easier to read.
Example:
Leads Converted Pipeline (Opportunity) Closed Won
Joe Smith 20 2,000 1,000
Jane Doe 40 5,000 3,000
In SQL, I would write a left outer join with USER against LEAD and OPPORTUNITY. How do I achieve the same thing in CRMOD? Basically, I want to show all the users within a sales group regardless of if they have totals for leads or opportunities.
0