Hi all,
I’m looking for help with monday.com dashboards.
I need to display a unique count of items based on a Connected Boards column.
If the same item is connected multiple times, it should be counted once, not multiple times.
Is there any widget, workaround, or solution that supports this?
Native, app, API, anything that actually works.
Thanks in advance.
Hi Michael, I think as of now monday.com dashboards don’t support counting unique items. We had a similar requirement to visualize data in a specific way, so we opted to use the API to pull data from monday.com boards into Power BI. This allowed us to build the visuals and reports exactly as needed.
Please let me know if you’d like more details or want to explore this approach further - I’d be happy to help!
Hi @TheKribus
This is a common limitation with monday.com dashboards. At the moment there is no native dashboard widget that can do a true unique count based on a Connected Boards column. The Numbers widget and chart widgets will count every connection even if the same item is linked multiple times.
The only reliable native workaround is to push the uniqueness logic down to the board level. One approach is to mirror the connected item ID or name into a text column and then use an automation or formula to flag the first occurrence only. You can then count only the flagged items in the dashboard. This requires some setup but works without external tools.
If you are open to apps the general category to look for is board to board rollups or advanced formulas. Some marketplace apps can deduplicate connected items before aggregating but results vary and most still struggle with true uniqueness.
For a solution that actually works consistently the API is the most robust option. You can query the connected boards data group by the connected item ID deduplicate it in code and then write the unique count back to a Numbers column that dashboards can read. Many teams run this via a scheduled script or lightweight serverless function.
In short there is no out of the box widget that does this today. Native requires a workaround on the board and the API is the cleanest and most reliable path if accuracy matters.
Hope that helps.