List Widget Unique List

[YogaYoda]

Reaching out for a bit of guidance since I've not been able to find an answer to my specific question. 

I have a dataset that has a NAME_ID field, there are tens of distinct of names in that field but thousands of rows. The dataset has a timestamp that ranges from roughly 3 years ago to present day. What I would like to know is if it is possible to use the List Widget to display the distinct names within the NAME_ID field, and to then to also display the total count of the distinct names? Also as an added complication the List Widget must also update to show the names and counts when filtered by date using the Date Selector. 

I'm assuming that I would need to use Arcade to accomplish what I'm looking for. 

Thank you!

[JenniferAcunto · Accepted solution]

Use a table disguised as a list. 

Dashboards That Pop: Unique Lists

[ShaneBradt]

This is a great tip @JenniferAcunto! I almost never used tables in my dashboards until I figured out this potential use. It certainly gets around the lack of a "grouped values" (or display distinct) option in the list element.

I used it for the first time in the NH Seafood Finder dashboard (the list of locations and type of seafood available once you choose a location) and have continued using it in many dashboards since.

[YogaYoda]

Hi Jen, sorry for the late reply. Thanks! This was very helpful!