Relating a field from one table to another for summary report

Question

I realize this question has been asked several times over here, but I can't quite wrap my head around how to take one of the existing solutions and apply it to my situation. Sorry for the duplication.

I have 2 tables with a parent child relationship, 1 parent to many child entries.

Running a summary report from the child table to summarize various fields in the child table entries for a date range.

The date of the child table entries resides within the child table entries

In a child table entry, we make a reference to a parent table entry. We'll call that field Related Parent Entry.

The problem I'm having is trying to get a unique count of Related Parent Entries into my summary report from the child table. The summary report can easily count how many entries have a Related Parent Entry value, but they're not unique.

I've also tried simply adding a category for the Related Parent Entry, but what the user really wants is a column with this count of unique values, not the actual values or an extra sorting/category of these values.

Any suggestion for getting a count of unique Related Parent Entry values into the child table report? Thank you.

quickbasecoachd · Answer

Are you just trying to count the distinct children?

For example the 4 stooges like Curly Larry Moe, and another Moe and more would result in a count of 3.

If so use the new Summary feature type called �Count Distinct�. It�s there in the drop down list when you AR making your susual summary fields.

jadal-ashkar · Answer

Thank you for the quick reply.&nbsp;&nbsp;Yes that's exactly what I'm trying to do.&nbsp; Count unique parent table references from the child table entries.&nbsp; 10 child table entries that only have 5 unique parent values should show '5'.The feature you're referring to, do you mean where I normally create a summary field in the table relationship?&nbsp; Here:https://community.quickbase.com/quickbase/topics/relating-a-field-from-one-table-to-another-for-summary-report?utm_source=notification&amp;utm_medium=email&amp;utm_campaign=new_reply&amp;utm_content=topic_link If so, I don't have that new feature for Count Distinct.&nbsp; I just have Total, Minimum, Maximum, Average, and Standard Deviation.I've also looked through the functions available when creating a calculated column, but I don't see any sort of 'distinct' or 'unique' function there.

quickbasecoachd · Answer

Its seems impossible that your drop down list of types of summary fields does not include Count Distinct. It is not a feature that is restricted to certain plans. Try making a brand new summary field.

If you still do not see that choice right after Combined Text, you will need to put in a support ticket.

jadal-ashkar · Answer

Scratch my last reply.&nbsp; I found that this new feature was released in February of 2019ish and we aren't going to have that in our quickbase implementation until some unknown time in the future.https://help.quickbase.com/release-notes/february-2019-release-notes.html#distinctWe don't have Combined Text or Count Distinct yet.&nbsp; :(&nbsp;

quickbasecoachd · Answer

That seems impossible. Is support saying that your plan does not include those features?&nbsp; It's not an advanced feature that costs more, so I don't understand,

Forum Discussion

Relating a field from one table to another for summary report

6 Replies

Related Content

Summary Table

Do unused tables related to currently used tables cause functionality problems?

Choosing Approvers from Related Table

Summary Formula?

Related Filtered field

Recent Discussions

Date value changes when copied to new table with pipeline.

Share your feedback on the new Qrew Discussions

'Is Set' in Pipelines

Time of Day field values are not in 24-hour format in Pipelines

Create a formula duration over 5 years