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.

SupportTPCloseRate

Data source: MSBilledPipeline

evaluate
summarizecolumns
(
Calendar[Fiscal Year],
Calendar[Fiscal Quarter],
'Account'[TPID],
'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],
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]>="FY23"),
filter('Product','Product'[Commercial Workload]="Support"),
"Close Rate Numerator",[Close Rate Numerator],
"Close Rate Denominator",[Close Rate Denominator]
)