Hello,
I am a technology coach working with elementary intervention specialists to create a reporting system with Looker Studio. Our hope is to create a form which allows the teachers to easily enter student data throughout the school year, and then, at the end of the year, generate a report through Looker Studio for each individual student. The report should show graphs indicating progress on various concepts.
Here are forms and items for this workflow (no student data is included in this mockup):
Here's my question: How do I get the graphs on the Looker Studio report to organize each concept by pre and post assessment, rather than combining the data, as it's currently doing? I can generate a graph on the spreadsheet doing just this, but cannot figure out how to do the same in Looker. Also, is it possible to have one graph for each concept rather than all together?
If it's because of the way the data is collected/organized on the sheet, I am happy to make changes. I just want to keep the data entry as simple as possible. Please feel free to make copies or changes as necessary.
Thanks!
Hey, just taking a look at this and it looks like you may have figured it out? The chart on Looker Studio and the chart on your Google Sheet seem to be grouping in the same way. Let me know if I'm missing something!
Yes, thank you! I just changed how data was entered on our form, and the spreadsheet was then able to match with the way Looker Studio operates. I appreciate you looking into this.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |