Forum Discussion
JadAl-Ashkar
6 years agoQrew Trainee
Thank you for the quick reply. Yes that's exactly what I'm trying to do. Count unique parent table references from the child table entries. 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? Here:
https://community.quickbase.com/quickbase/topics/relating-a-field-from-one-table-to-another-for-summary-report?utm_source=notification&utm_medium=email&utm_campaign=new_reply&utm_content=topic_link
If so, I don't have that new feature for Count Distinct. 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.
The feature you're referring to, do you mean where I normally create a summary field in the table relationship? Here:
https://community.quickbase.com/quickbase/topics/relating-a-field-from-one-table-to-another-for-summary-report?utm_source=notification&utm_medium=email&utm_campaign=new_reply&utm_content=topic_link
If so, I don't have that new feature for Count Distinct. 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.