Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

OpportunityPartner

Data source: OCPInsightSASCRM

EVALUATE
SUMMARIZECOLUMNS
(
'Reporting PartnerOne'[PartnerOne Name],
'CRM Partner Account'[Partner Account Name],
'Opportunity'[Opportunity Number],
'Sharing Type'[Sharing Type],
'Partner Deal'[PartnerOne ID],
'Partner Deal'[PartnerOne Name],
'Partner Deal'[Partner Deal ID],
'Partner Deal'[Partner Deal URL],
'Partner Deal'[Status],
'Partner Deal'[Partner Deal Direction],
'Partner Deal'[Partner Acceptance Status],
'Partner Deal'[Partner Acceptance Status(PartnerCenter)],
'Partner Deal'[Partner Acceptance SubStatus(PartnerCenter)],
FILTER('Opportunity', NOT(ISBLANK('Opportunity'[Opportunity Number]))),
"# Co-Sell (Oppty)",[# Co-Sell (Oppty)],
"Count of Opportunities",[Count of Opportunities],
"Count of Draft Opportunity",[Count of Draft Opportunity]
)