I am trying to link data from two separate activities: a Feedback activity and a Quiz activity. I would be fine exporting the reports for each as long as I had a common field that I could use as a key.
What I need and what I get from the Feedback activity:
I want a report of student responses to include a field to use as a key. When I export the responses for the Feedback activity, I get a report that includes USERNAME and FULL NAME fields.
What I need and what I get from the Quiz activity:
I want a report of student responses to include a field to use as a key. When I export the responses for the Quiz activity, I get a report that includes FIRST NAME, LAST NAME, and EMAIL.
Why don't the reports both include common identifying fields? Username or Email fields would be fine. UserID would be great. But, as it stands, I wouldn't be able to tell the difference between two students with the same name because there is no unique identifier that is common between the reports. I would have to pull up a separate report of Enrolled Users just so that I can cross-reference by USERNAME and EMAIL so I could tell who is who.
I would like two things that would help me out tremendously:
1. If anyone knows how to add a common field to either report, please let me know.
2. If the built-in queries and reports could be adjusted to include a common identifying field, I could do much more with the reports.