Hey Sayed Wali and Bryan, Andree,
Sorry for missing your earlier question Sayed. What I was referring to is that when I build my dashboards a lot of data processing happens before I even create my dashboards.
I use a variety of different tools to create my datasets like python or FME to find all the values and add them up in a spreadsheet. You could also do a field calculation in ArcGIS Pro to loop through all your features and create a sum field based on the name of the feature. Once you have done that if you remove all the other instances so you are just left with the distinct values then you should have your features that can be published.
The problem a lot of the above have is the amount of overhead required to fix up the data and to maintain it. When pulling from data sources you don't control data schemas can change or naming conventions can change. You will also need to automate these processes or manually rerun them when you want to update the datasets.
A lot of work can go into these dashboards and the data behind them!
Thanks,
Ben