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.

TPCloseRate

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS
(
'Account Information'[TPID],
'Geography'[Area],
'Geography'[Subsidiary],
'Solution Area'[Commercial Workload],
'Product'[Super Rev Sum Division],
'Product'[Rev Sum Division],
'Product'[Rev Sum Category],
'Product'[Product Family],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Product'[Dynamics Workload],
filter('Calendar', 'Calendar'[Fiscal Year]>="FY21"),
"Close Rate",[Close Rate],
"Close Rate Numerator",[CloseRateNum],
"Close Rate Denominator",[CloseRateDenom]
)