Is it possible to use Arcade inside an element on a dashboard? Or do I need to do the math in a web map and then refer to that field?
Here's what I'm trying to do (fake data for illustration):
| Fed Source 1 | Fed Source 2 | Local Source 1 | Local Source 2 | Local Source 3 |
| $999 | $999 | $444 | $444 | $444 |
| $523 | $231 | $123 | $153 | $9751 |
| $6237 | $94086 | $0 | $0 | $0 |
| $0 | $0 | $992 | $1000 | $904 |
I want to create a donut chart that shows the percentage of federal funding versus local funding. My thought was that I could write an Arcade statement to add up Fed Source 1 and Fed Source 2 and call it FED, then write an Arcade statement to add up Local Source 1, Local Source 2, and Local Source 3 and call it LOCAL. I'm not seeing any place inside Dashboards where I can do statements like this, but I thought I'd ask to be certain.