Removing Duplicates in a listing table

dweaver — Tue, 17 Dec 2024 15:11:00 GMT

I was trying to create a very simple listing table of a few columns (Brokers name, Sales office, customer). It works however it is displaying duplicate rows of data. Is there a way to do a distinct on a listing table? Or is there a way to remove duplicates?

Re: Removing Duplicates in a listing table

JoeM — Tue, 17 Dec 2024 16:30:17 GMT

@dweaver -
Bring all of those columns into the measure tray. Once there, you'll also see the presence of a 'distinct filter' tray. Drag those same column names in again to create your distinct filter.

Note that you may get an error forming the query plan since you don't have a quantitative measure. I'd drag in a measure, take note of the base table in the query plan, remove it, and then set your #ERROR columns to have a base field from that base table that was noted.

topic Re: Removing Duplicates in a listing table in Dashboards & Analytics Discussions

Removing Duplicates in a listing table

Re: Removing Duplicates in a listing table