Jacob, hard to tell from you description what exactly you're trying to do, so two comments:
- Go here and follow the link to the best way to visualize survey data via Joe Mako.
- If that doesn't motivate you change your viz, then post a packaged workbook with some sample data.
Thank you for the reply. Please see the attached packaged workbook, and specifically, the last tab titled "Operations Diagnostic." Essentially, I am looking to create a third column which is the difference between the 1st column and the second column (i.e. a gap analysis). Does this clarify it a bit? The first column has an alias but is one respondent, and the second column is a grouping of respondants.
There are a couple of ways to do this. One way is to add a Difference Table Calculation to Avg Response (right click on in on the text shelf and select Quick Table Calculation-->Difference. Then, place another instance of Avg Response on the view. (Refer to Sheet8).
Another option is to create a couple of calculated fields. First, a calculated field will need to be created to group (Q1_1)1#Your Name (Question) into the two types (an ad hoc group cannot be referenced in a calculated field). Then, for each of the two groups a calculated field will need to be created. (Refer to Sheet7).
Hope one of these options help!
Thank you very much, this is very helpful! While the first option is definitely easier, the second option will likely help me with some more complex versions of this issue.