I have some data in a table that I would like to perform some statistics and have that placed in a text box on my map Layout. While I could do this by hand, I'd like to do it dynamically so when I update the data later on I don't have to edit my text boxes.
My data looks something like this:
| County | POP2019 | Deaths | |--------|---------|--------| | Benton | 1000 | 2 | | King | 100 | 1 |
I want to do a statewide death rate calculation like this
((Sum of Deaths / Sum of Population) * 100) Round to 5 decimals Round(((Sum($feature.Deaths) / Sum($feature.POP2019)) * 100), 5)
But that dynamic text expression doesn't sum up the column! It prints out each and every row, and does not sum them up.