Impressive use of Chat GPT.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 03-26-2023 13:09
From: Matt Makris
Subject: List unique parent record counts in child table Summary Report
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
Original Message:
Sent: 03-26-2023 11:42
From: Matt Makris
Subject: List unique parent record counts in child table Summary Report
I have a Clients table (parent) and a Products table (child). I am trying to list how many Clients 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.
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
------------------------------