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.

Engagement

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'Geography'[Area Short Name],
'Geography'[Subsidiary],
'Account Information'[Top Parent],
'Account Information'[TPID],
'Engagement'[Engagement CRM-ID],
'Engagement'[Engagement Name],
'Engagement'[Engagement Status],
'Engagement'[Engagement Health],
'Engagement'[Engagement Stage],
'Solution Area'[Solution Area],
'Engagement'[Engagement Estimated Start Date],
'Engagement'[Engagement Estimated Completion Date],
'Engagement'[Engagement Created By Alias],
'Engagement'[Engagement Created By Standard Title],
'Engagement'[Engagement Owner],
'Engagement'[Engagement Owner Standard Title],
'Engagement'[Engagement Ownership Group],
'Engagement'[Engagement URL],
'Engagement'[Engagement Age Group],
'Engagement'[Primary Competitor],
'Engagement'[Competitor Threat Level],
'Engagement'[MS Services Involved],
'Sales Group'[Sales Unit],
'Engagement'[GBB Attach Flag],
'Engagement'[Engagement Created Date],
'Engagement'[Engagement Partner Name],
'Engagement'[Engagement Partner Attach Flag],
'Engagement'[Engagement Sales Play Checklist],
'Engagement'[Engagement Stage Started On],
'Engagement'[MCS Attach Flag],
'Engagement'[MCS Engaged Flag],
'Engagement'[Engagement Workload Type],
'Segment'[SubSegment],
FILTER('Engagement Workload', OR (Left('Engagement Workload'[Engagement Workload],17) in { "Infra: Azure Sec ","Infra: Monitoring"},'Engagement Workload'[Engagement Workload] in {"Infra: Native Azure Virtual Desktop","Infra: Citrix + Azure Virtual Desktop","Infra: Horizon + Azure Virtual Desktop (VMware)","MW: Teams Phone"} )),
FILTER('Account Information','Account Information'[HQ DS Flag]<>"DS"),
"Engagement Count", [Engagement Count],
"Engagement Milestone Count", [Engagement Milestone Count]
)