10 Oct 2023 09:49 PM
How can I add up the total amount received and categorize by country?
Solved! Go to Solution.
11 Oct 2023 08:33 AM
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