Select to view content in your preferred language

Update card with sum of count field based on chosen timeline

135
1
a week ago
OliverAdams-Thorbjoernsen
New Contributor

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

1 Reply
TonghuiMing
Esri Regular Contributor

@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