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.

SupportCloseRate

Data source: MSBilledPipeline

evaluate
summarizecolumns
(
Calendar[Fiscal Year],
Calendar[Fiscal Quarter],
'Account'[Area Short Name],
'Account'[Custom Area],
'Account'[Subsidiary],
'Account'[Assigned Hyper Sales Group],
'Account'[Assigned Sales Unit],
'Segment'[Field Segment],
'Segment'[Sub Segment],
'Account'[Industry],
'Account'[Vertical],
'Product'[Commercial Workload],
'Product'[PPG Category],
'Product'[PPG],
'Product'[Product Family],
'Primary Product Grouping'[Business Scenario],
filter('Segment','Segment'[Field Segment] IN {"Strategic Commercial","Strategic Public Sector","Major Commercial","Major Public Sector","SM&C Corporate","SM&C SMB"}),
filter(Calendar,Calendar[Fiscal Year]>="FY22"),
filter('Product','Product'[Commercial Workload]="Support"),
"Close Rate Numerator",[Close Rate Numerator],
"Close Rate Denominator",[Close Rate Denominator],
"Run Rate Close Rate Numerator",[Run Rate Close Rate Numerator],
"Run Rate Close Rate Denominator",[Run Rate Close Rate Denominator],
"Blended Close Rate Numerator",[Blended Close Rate Numerator],
"Blended Close Rate Denominator",[Blended Close Rate Denominator]
)