Has anyone else struggled with the way survey reports are generated? I had around 80 sessions, so the spreadsheet I received had 80 tabs, which is fine except that...
- I had to go through and name each tab so I know which session it was for.
- The headers for each row are actually in row 5, so there's not an easy way to generate graphs/etc without first deleting the top 4 rows. I have to do that on 80 tabs.
- The numbers for the responses (1-5) came through as text, not numbers, so I had to do a huge workaround to convert them all to numbers so I could do something as simple as highlighting a row to see the average.
- The speaker name is not included in the output, so I'll need to add that in for each tab as well if I want to see speaker data at a quick glance.
- I'd love to be able to run a report on a speaker who taught multiple sessions so it is all together in one sheet instead of multiple tabs.
Am I missing something in the setup of the report to make my life easier when I try to create visual graphics of the data? Would love any help anyone out there can offer!
#ReportingandInsights------------------------------
Jen Howver
Training Manager
Christian Camp And Conference Association
------------------------------