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.

SupportRecaptureRate

Data source: powerbi://api.powerbi.com/v1.0/myorg/ESA_CES_Prod

EVALUATE
SUMMARIZECOLUMNS (
'Date'[MS Fiscal Month Name],
'Delivery Geography'[Area Name],
'Delivery Geography'[Sales District Name],
'Delivery Geography'[Sub Region Name],
'Delivery Geography'[Subsidiary  Name],
'Renewal Metrics'[Category Type],
'Renewal Metrics'[Renewal Level],
'Renewal Metrics'[Renewal Sub Level],
'Top Parent Account'[Custom Segment],
'Top Parent Account'[MS Sales Top Parent ID],
'Top Parent Account'[MS Sales Top Parent Name],
'Top Parent Account'[TP Sub Segment Name],
FILTER('Date', 'Date'[MS Fiscal Year Name] >= "FY2023"),
FILTER('Renewal Metrics', 'Renewal Metrics'[Category Type] in {"Premier Classic", "Transition", "Unified Support"}),
"YTD_AnnualizedPriorRevenue", [Annualized Prior Revenue],
"YTD_Annualized Revenue", [Annualized Revenue]
)