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.

SellerTechnicalSkilling

Data source: asazure://westus2.asazure.windows.net/wwlbianalytics

EVALUATE
CALCULATETABLE (
SUMMARIZECOLUMNS (
'User Classification'[Standard Title],
'User Classification'[Qualifier 1],
'User Classification'[Qualifier 2],
'User Classification'[User Status],
Assignment[RoadMapConsumptionType],
'Finance Geography'[Area],
'Finance Geography'[Region],
'Finance Geography'[Sub Region],
'Finance Geography'[Sales Location],
'Finance Geography'[Sales Sub Location],
'Finance Geography'[Sales District],
Assignment[Assignment],
Assignment[Category 1],
Assignment[Category 2],
Assignment[Category 3],
'Completion Time'[Fiscal Year],
'Completion Time'[Fiscal Quarter],
'Completion Time'[Fiscal Month],
'Complete By Time'[Level 2],
'Completion Time'[Date],
"Assignments Targeted", [Assignments Targeted],
"Assignments Completed", [Assignments Completed],
"Assignments Completion %", [Assignments Completion %]
),
KEEPFILTERS (
TREATAS ( { "Specialist Sales" }, 'Finance Organization'[Organization] )
),
KEEPFILTERS (
TREATAS ( { "Required", "Recommended" }, Assignment[RoadMapConsumptionType] )
)
)