topic Filter table on duplicate values in App Development

Filter table on duplicate values

mikegrattan — Fri, 27 Aug 2021 18:52:59 GMT

I've got the following formula that shows me if a check number is duplicated, but now I want to filter the table to show only those checks that are duplicates. Please advise. Thank you.

=If(count(TOTAL <CheckNo> CheckNo)>1,1,0)

Re: Filter table on duplicate values

stevejoyce — Fri, 27 Aug 2021 19:07:50 GMT

For on-the-fly calculation of duplicate (i.e. taking our selections in to account) use below.

convert to a calculated dimension using aggr, you can move this to set analysis as well:

When you select 1, it will select the combination of fields in your aggr(), so in the below it will select the CheckNos that have duplicates.

=alt(aggr(count(distinct{<CheckNo= {"=count(CheckNo) > 1"}>} 1), CheckNo),0)

If you can/want to have it based on entire data set, you can create your duplicate flag in the data model as a field, with count / groupby.

Re: Filter table on duplicate values

mikegrattan — Fri, 27 Aug 2021 19:41:27 GMT

This works perfectly, thank you!

Re: Filter table on duplicate values

stevejoyce — Fri, 27 Aug 2021 20:12:38 GMT

@mikegrattan great! please mark solution so post can be closed and marked appropriately.