Creating reports - calculating entries from multiple forms
I need to build a report based on the same form being filled out multiple times by the same user. We are recording the number of each users consistent responses and changes over several instances.
The following is an example of the form, the user must select one or multiple decision boxes. The form automatically determines sum total, percentage and time taken,
The user then will complete this same form several more times.
We need to create a report that can
- filter by user name and time period and then displays the
- Total number score of each checked Decision box (there may be up to 12 decision boxes)
- Average overall Percentage Score
- and Average time taken to complete the forms
The report can be either as a summary list or a bar chart
Below is an example
Can this be done in Creator Reports?
Thanks in advance
Ian