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.

OpportunityVelocity

Data source: PipelineAS

EVALUATE
SUMMARIZECOLUMNS(
'Opportunity'[CRM Opportunity ID],
'Account Information'[TPID],
'Geography'[Subsidiary],
'Sales Group'[Sales Unit],
'Segment'[SubSegment],
FILTER('Solution Area', 'Solution Area'[Solution Area] IN { "Modern Work", "Security","Modern Work & Security" }),
"DaysInStage20", [Days in Develop Strategy 20%],
"DaysInStage40", [Days in Present Value 40%],
"DaysInStage60", [Days in Prove Value 60%],
"DaysInStage80", [Days in Negotiate Terms 80%]
)