Add total sales and categorize via dql

[WellPP]

How can I add up the total amount received and categorize by country?

[sinisa_zubic · Accepted solution]

hi @WellPP 

I think you are looking for this query

fetch bizevents
| filter event.type == "com.easytravel.funnel.booking-finished"
| fields amount, geo.country.name
| summarize total = sum(amount), by:{geo.country.name} 

Best,
Sini