https://community.esri.com/t5/data-management-questions/double-vs-string-field-for-serial-chart-in/m-p/1416770#M45112 <P>I am creating a dashboard that shows funded grants over the past 20 years. I created a base map in ArcPro and uploaded it as a webmap to use in the dashboard. I want to portray a serial chart on the dashboard that shows how much funding was allocated per year (amount awarded), but I cannot get the serial chart to display that for some reason. It will not let me do a 'Sum' of the amount awarded when choosing the statistic for the award year. I believe this is because the field in the attribute table for amount awarded is in String instead of Double. I updated the attribute table in ArcPro so that it copied the amount awarded in Double format, but now when I upload that back onto GIS online, the web map shows all blank values for that field. How can I get the webmap to show the amount awarded in Double instead of String so that I can create the serial chart?&nbsp;</P> Mon, 29 Apr 2024 22:40:30 GMT OliviaJohnson 2024-04-29T22:40:30Z https://community.esri.com/t5/data-management-questions/double-vs-string-field-for-serial-chart-in/m-p/1416770#M45112 <P>I am creating a dashboard that shows funded grants over the past 20 years. I created a base map in ArcPro and uploaded it as a webmap to use in the dashboard. I want to portray a serial chart on the dashboard that shows how much funding was allocated per year (amount awarded), but I cannot get the serial chart to display that for some reason. It will not let me do a 'Sum' of the amount awarded when choosing the statistic for the award year. I believe this is because the field in the attribute table for amount awarded is in String instead of Double. I updated the attribute table in ArcPro so that it copied the amount awarded in Double format, but now when I upload that back onto GIS online, the web map shows all blank values for that field. How can I get the webmap to show the amount awarded in Double instead of String so that I can create the serial chart?&nbsp;</P> Mon, 29 Apr 2024 22:40:30 GMT https://community.esri.com/t5/data-management-questions/double-vs-string-field-for-serial-chart-in/m-p/1416770#M45112 OliviaJohnson 2024-04-29T22:40:30Z