topic Re: filter by distinct value in ArcGIS Insights Questions

filter by distinct value

LauraBecht — Fri, 21 Jan 2022 14:15:51 GMT

Hi,

I have a table of accounts that have been joined to a table of taxing authorities in a many to one relationship. I need to summarize by the distinct account for a given taxing authority which has multiple city/mill codes. is this possible?

Thanks,

Laura Becht

Re: filter by distinct value

ScottSandusky — Mon, 24 Jan 2022 16:25:32 GMT

Hi Laura, will the summary table work for this? Use the variables that you want to summarize and get the distinct counts for?

Re: filter by distinct value

LauraBecht — Mon, 24 Jan 2022 16:38:58 GMT

Hi Scott,
That is kind of what I am doing, but it doesn't allow for a unique count or value sum for the whole tax authority due to the duplicates. What I am looking for is a way to filter the kpi for distinct parcel id's/accounts, kind of like select distinct in sql. I have the summary by tax authority in a summary page, but was hoping to be able to effect the same on the parcel/tpp account page, more so the user doesn't have to switch back and forth.
Laura