Discussions

 View Only
  • 1.  List unique parent record counts in child table Summary Report

    Posted 03-26-2023 11:43

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


  • 2.  RE: List unique parent record counts in child table Summary Report

    Posted 03-26-2023 13:09

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



  • 3.  RE: List unique parent record counts in child table Summary Report

    Posted 03-26-2023 13:11

    Impressive use of Chat GPT.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: List unique parent record counts in child table Summary Report

    Posted 03-27-2023 11:09

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