Forum Discussion

DanielOates's avatar
DanielOates
Qrew Member
8 years ago

Need help creating a Frequency report that will count from 2 different fields

In a table,  Field X and Field Y  are both multiple choice with identical choices.    I need to create a Frequency report that will count the choices selected in both of these, as if they were only one field.     Is this a possibility?         For instance:    On one record,   Field X  shows "cat",  and on a different record  Field Y  shows "cat".    I need to run a frequency report that will show that "cat" was selected twice.   
App builders
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    If you have your selection lists in related parent tables, you can create summary fields in the parent tables that would allow you to see how many times the 'cat' record was selected in a child record.

    Summary fields essentially count the number of child records that meet a condition you specify.

    In this case, when you go to create the summary field, you can just click through without specifying conditions.

    You'd then consult the parent selection lists' summary fields to see how many child records chose the 'cat' record, or the 'canary' record, or the 'canine' record, etc.

    Hope this helps.