We are analyzing this KQL query:
Sales
| where Status != "Cancelled"
| where OrderDate >= ago(30d)
| summarize TotalSales = sum(SalesAmount) by ProductCategory
| where TotalSales > 0
Statement 1:
"The query excludes sales that have a Status of Cancelled."
Yes → where Status != "Cancelled" filters them out.
Statement 2:
"The query calculates the total sales of each product category for the last 30 days."
Yes → where OrderDate >= ago(30d) ensures only last 30 days.
summarize TotalSales = sum(SalesAmount) by ProductCategory groups by category.
Statement 3:
"The query includes product categories that have had zero sales during the last 30 days."
No → The final filter where TotalSales > 0 excludes categories with zero sales.
Final Answer:
Excludes Cancelled sales → Yes
Calculates total sales by product category for last 30 days → Yes
Includes product categories with zero sales → No
