List unique parent record counts in child table Summary Report

Question

I have a Clients table (parent) and a Products table (child). I am trying to list how many Clients&nbsp; records are related to records in the Products table. The `Product Name` from the Products (child) table is the primary dimension in the report. The metric is `# of Clients` associated with each Product Name. Some Client records are associated with more than one product, which is showing up in the `# of Clients` value.&nbsp;
Is it possible for the `# of Clients` value to reflect the number of unique client records, rather than counting a client 2+ times in the event that Client record has more than one Product record association?

Thanks!------------------------------Matt Makris------------------------------

mattmakris · Answer

I figured it out with help from ChatGPT. Apparently it has been trained on all Quickbase user guides and API guides.
Solution: Rather than summarizing `# of Clients`, I summarized the `Related Client` record ID field and set 'Summarize by' to "Distinct Count".------------------------------Matt Makris------------------------------

markshnier__you · Answer

Impressive use of Chat GPT.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

brianseymour · Answer

Nice solution via ChatGPT! Using Distinct Count via a Summary seems like the way to go here since the relationship exists between the records (vs. Formula Queries).

------------------------------
Brian Seymour
------------------------------

Forum Discussion

List unique parent record counts in child table Summary Report