I have a table with about 1000 records. I need to average and chart individual fields across all records (figured out how to do that). However I can't figure out how to:
Group multiple fields to create a single average (i.e. by section) and then chart those averages.
Example: There is a greeting section with approximately 7 fields. I need to determine the average of the responses for the entire section and then chart it next to averages from other sections.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
TroyPurdue
I have a table with about 1000 records. I need to average and chart individual fields across all records (figured out how to do that). However I can't figure out how to:
Group multiple fields to create a single average (i.e. by section) and then chart those averages.
Example: There is a greeting section with approximately 7 fields. I need to determine the average of the responses for the entire section and then chart it next to averages from other sections.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.