I’m using the Qualtrics Report format to create an output for clients after they take a survey. I want to be able to create graphs that show the averages for individual items as well as averages for groups of items. For example, if items 1-5 are part of group A and items 6-10 are part of group B, I want graphs that show the averages for each item 1-10 as well as averages for group A and B.

I’ve tried creating scoring with groups, but that gives me the sum of all the items in the report instead of an average. Such that, if a participant responded 5 - “strongly agree” on all items, the report would show a graph of 25 instead of 5.

I’ve also tried piped text, but that doesn’t give me a quantitative item to use in the report.

I have found that I can create an item, download the data, create the average in Excel, upload the data back into qualtrics as the new item, and then use that in the report. However, I’m hoping for a more streamlined way of doing this. If this is the only way to do this, I’d rather just manually make the graphs in Excel.