topic Re: Update card with sum of count field based on chosen timeline in ArcGIS Experience Builder Questions https://community.esri.com/t5/arcgis-experience-builder-questions/update-card-with-sum-of-count-field-based-on/m-p/1527654#M14534 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/797145">@OliverAdams-Thorbjoernsen</a>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>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 -&nbsp;</P><P>- Create a data view with sort: count, desc</P><P>- Use the max count = 1</P><P>- Configure your timeline widget as usual, and the filtering will pass onto the data view</P><P>- Then use the dynamic content, either in Text/Button, etc. to show the country name of the result, using the created data view</P> Tue, 27 Aug 2024 06:55:56 GMT TonghuiMing 2024-08-27T06:55:56Z Update card with sum of count field based on chosen timeline https://community.esri.com/t5/arcgis-experience-builder-questions/update-card-with-sum-of-count-field-based-on/m-p/1526788#M14487 <P>I have data which has the fields datetime,country,count (int)</P><P>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.</P><P>Is this possible?</P><P>Thanks in advance</P> Sat, 24 Aug 2024 15:49:42 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/update-card-with-sum-of-count-field-based-on/m-p/1526788#M14487 OliverAdams-Thorbjoernsen 2024-08-24T15:49:42Z Re: Update card with sum of count field based on chosen timeline https://community.esri.com/t5/arcgis-experience-builder-questions/update-card-with-sum-of-count-field-based-on/m-p/1527654#M14534 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/797145">@OliverAdams-Thorbjoernsen</a>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>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 -&nbsp;</P><P>- Create a data view with sort: count, desc</P><P>- Use the max count = 1</P><P>- Configure your timeline widget as usual, and the filtering will pass onto the data view</P><P>- Then use the dynamic content, either in Text/Button, etc. to show the country name of the result, using the created data view</P> Tue, 27 Aug 2024 06:55:56 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/update-card-with-sum-of-count-field-based-on/m-p/1527654#M14534 TonghuiMing 2024-08-27T06:55:56Z