Update card with sum of count field based on chosen timeline

Question

I have data which has the fields datetime,country,count (int)

I am trying to setup a card so the card can display the country with the highest sum of count within the chosen time frame.

Is this possible?

Thanks in advance

TonghuiMing · Answer

@OliverAdams-Thorbjoernsen

I am not sure what the expectation is for the "country with the highest sum of count." If you use SUM to add the count values, then it is just a number, right?

On the other hand, if you meant, "display the country with the highest count (field) within the chosen time frame", then you may try this method -

- Create a data view with sort: count, desc

- Use the max count = 1

- Configure your timeline widget as usual, and the filtering will pass onto the data view

- Then use the dynamic content, either in Text/Button, etc. to show the country name of the result, using the created data view