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

Priyanka
Priyanka Member
in Beast Mode
Count as per Country.JPG

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

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited January 2024 Answer ✓

    @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"

    Screenshot 2024-01-26 at 8.21.26 AM.png
    Screenshot 2024-01-26 at 8.22.13 AM.png

    If I solved your problem, please select "yes" above

Answers

  • GrantSmith
    GrantSmith Coach

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Priyanka
    Priyanka Member
    edited January 2024

    # 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
    ColemenWilson Coach
    edited January 2024 Answer ✓

    @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"

    Screenshot 2024-01-26 at 8.21.26 AM.png
    Screenshot 2024-01-26 at 8.22.13 AM.png

    If I solved your problem, please select "yes" above

Categories