Forum Discussion
Analyse survey results completed twice over time of support
Hello, I have an MSForm with 8 questions about wellbeing where every answer will be from 1-10. I work for a charity and we want to complete this form with a young person when they start working with...
Well, for one thing, to do a year over year comparison you would have to have data from two years (or more). I've added some rows of random data, and changed the field to just be a date. (Do you really need the time of start and the time of completion? If so, fine, but I'd make it simpler to summarize by also have a field that is a simple date)
Then the Pivot Table does a good job of summarizing. I've given one example, but there are all kinds of ways to use a Pivot Table with a single set of data. Here's a reference you might find useful. There are also many MANY instructional videos on YouTube.