Hey Sayed Wali,
I don't think this is possible without some custom coding or calculating those fields before pushing it to ArcGIS Dashboards. If you are intereseted in this feature you may want to vote for this idea: Operations Dashboard widget to display count of distinct unique values
If this answer was helpful please mark it as helpful. If this answer solved your question please mark it as the answer to help others who have the same question.
Hi Ben Turrell,
Thank you for your reply. I went into the link you provided and is useful. Can you explain more about your first point, how is it possible to code before publishing to Dashboard? do you mean to maintain some Arcade expressions in webmap?
What I want to build is a list and a distinct count of related features exactly like the COVID-19 dashboard:
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!