Forum Discussion

KarmenRouland's avatar
KarmenRouland
Qrew Trainee
6 years ago

Formulas and Reports

Hello. I have a field "equity focus area" that has five different data choices (race, gender, national origin, religion, and SES). The field "equity focus area" is in a table named "Project" and each "Project" can have multiple "equity focus areas". For example, one project could be about "race" and "religion". I am interested in learning how I can count each instance of an "equity focus area" to display in a report such as a pie chart. Currently, the "equity focus area" field is a multi-select text format.
Formulas and functions
reports and charts
Tables and fields

15 Replies

Sort By
Show More
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    Often user choose a multi select field and then run into all kinds of data analysis issues as they do not really lend themselves to any kind of reporting.  The Pie charts would be done off the child records, and this new feature coming out on December 16th will allow the unique child values to be summarized up to the parent as a text string.

    I had the opportunity to see this is action on a test app as I was giving feedback to Product Manager.  This will save me a lot of time in explaining how to do reverse relationships,  here on this forum,  to float up text values from children to parents, as now it will be a native feature.