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