How to calculate count of Devices as per country using beast mode ?

Priyanka

In above screenshot, I want Italy should show 4 Devices
Thank You!

ColemenWilson

@Priyanka check your sorting and date range. Incorrect sorting or graph by settings in the date range can cause data to not be aggregated as intended. As an exercise you can remove sorting fields and in graph by select "none"

GrantSmith

Is # Devices a beast mode? If it's a column you can select the column in the table and under aggregation select SUM. If it's a beast mode you can wrap it in a SUM value depending on how your beast mode is written.

Priyanka

# Devices, yes its beast mode - COUNT(Order Number) (Order Numbers are unique) how can we group Italy and will show count 4.
So I want a table in a such way that country will show total number of orders against it ,so could you please assist ?
Thank you so much for your quick response!
@ GrantSmith

ColemenWilson

@Priyanka check your sorting and date range. Incorrect sorting or graph by settings in the date range can cause data to not be aggregated as intended. As an exercise you can remove sorting fields and in graph by select "none"