Discussions

Expand all | Collapse all

Summarize distinct child records by a text field

  • 1.  Summarize distinct child records by a text field

    Posted 28 days ago
    I have a parent table (Botruns) that has many children (Line items). The line items could either be processed or not processed and the data for that resides in the line item record in the child table. These line items have an identifier SvcOrderLine# which need not be unique.

    I know how to summarize the distinct SvcOrderLines in the parent table. But how do I summarize the reasons the distinct lines were not processed when those reasons are captured on the line item record? I was able to create a 'combined text' summary field in the Parent table for 'Reason not processed' but how do I count them now?

    - Deepa

    ------------------------------
    Deepa Deepa
    ------------------------------


  • 2.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    Are you simply trying to count the number of unique reasons for not being processed. Is that the goal?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    Yes, but the reasons are recorded on the child record in text format in a field 'Reason not processed'. Each child record has a field called SvcOrderLine# which if unique will determine which child records to count. But in the child table itself, the line record is not marked as unique. While I can do a distinct count of unique child records, how do I do a distinct count of each 'Reason not processed'?

    ------------------------------
    Deepa Deepa
    ------------------------------



  • 4.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    Are you looking to count the unique combinations of the SvcOrderLine# and the Reason not processed?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    To clarify by counting the reasons, I assume i will know by reason description the count.
    1. PWO only - count
    2. Locked by user - count etc.

    ------------------------------
    Deepa Deepa
    ------------------------------



  • 6.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    I suggest that you give an example of the child data and the result that you expect.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Summarize distinct child records by a text field

    Posted 28 days ago
    Mark,
    I just needed you to push me and get me to think. I figured it out :-)

    Thanks!!!




    ------------------------------
    Deepa Deepa
    ------------------------------