cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Add total sales and categorize via dql

WellPP
Participant

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

 

WellPP_0-1696970957591.png

 

1 REPLY 1

sinisa_zubic
Dynatrace Champion
Dynatrace Champion

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

Featured Posts