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.

EngagementMilestoneUsage

Data source: KPILakeAS

EVALUATE
SUMMARIZECOLUMNS(
'Engagement Milestone Usage'[Milestone CRM-ID],
'ACR Adjustment Type'[ACR Adjustment Mid Group],
'Calendar'[Fiscal Year],
'Calendar'[Fiscal Quarter],
'Calendar'[Fiscal Month],
'Engagement Milestone Usage'[Milestone Est. Monthly Usage],
FILTER('Calendar', [Fiscal Year] = "FY21" || [Fiscal Year] = "FY22" || [Fiscal Year] = "FY23"),
FILTER('Engagement Workload', OR (Left('Engagement Workload'[Engagement Workload],17) in { "Infra: Azure Sec ","Infra: Monitoring"},'Engagement Workload'[Engagement Workload] in {"Infra: Native Azure Virtual Desktop","Infra: Citrix + Azure Virtual Desktop","Infra: Horizon + Azure Virtual Desktop (VMware)","MW: Teams Phone"} )),
"Azure Consumed Revenue Pipeline", [Azure Consumed Revenue Pipeline],
"Azure Qualified Pipeline",[Azure Qualified Pipeline],
"Azure Non-Qualified Pipeline",[Azure Non-Qualified Pipeline],
"Qualified Pipeline w/GBB",[Qualified Pipeline w/GBB],
"Milestone Estimated Monthly Activations Rollup",[Milestone Estimated Monthly Activations Rollup],
"Row Count",COUNTROWS('Engagement Milestone Usage')
)