Forum Discussion

MattMakris's avatar
MattMakris
Qrew Cadet
2 years ago

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
------------------------------

3 Replies

Sort By
  • MattMakris's avatar
    MattMakris
    Qrew Cadet
    2 years ago

    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's avatar
      MarkShnier__You
      Qrew #1 Challenger
      2 years ago

      Impressive use of Chat GPT.



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
    • BrianSeymour's avatar
      BrianSeymour
      Qrew Cadet
      2 years ago

      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
      ------------------------------