Which data set are you using in the Packaged workbook? I'm not seeing which one to use. Which 4 statements are you looking to plot?
PS: if there is any sensitive data in here, I'd remove the workbook and only attached the data you want us to see. all of your sheets are still on here
If you look at the sheet entitled, master data set - I am referring to columns 8-12 called
'Duration (Q3)' Which i hope to plot on the Y axis, and then the following 4 statements on the x-axis:
The points on the graph itself would be made up of the respondents which is the first column in the sheet, where have 51 respondents in total. So i hope to plot all 51 responses for each of the 4 statements.
Is this of any help?
Yes! That looks like what I am trying to achieve! You managed to do it quick I wish i posted earlier.
How did you manage to achieve that?
Here are the steps I followed:
- Drag Duration (Q3) to the Columns shelf and make it a Dimension from the drop down
- Drag Measure Names to Filter and select the four measures you want to use
- Drag Measure Values to the Rows shelf
- Draft Measure Names to the Color Marks Card
That should do it. Let me know if it trips you up or if you're looking for something else.
Thats great! that seems to have got me the graph i was looking for.
Although it displays the lines as an average of the points.
Would it be possible to have it so i have all 51 of the users plotted on each line - in other wards so I can hover over an area of a line and it will tell me which respondent said gave that response on the x axis and that response on the y-axis?
For example currently when I hover over a point the tooltip tells me:
People who have been at the company for two years gave speed of the system an average rating of 5.6.
Where as i would really like to know:
Respondent number 10 - has been in the company 2 years and rated speed of the system a rating of 5.6.
Do you understand? Is there a way to also know or add in which row of the spreadsheet ie: which user is saying this information?
1 of 1 people found this helpful
Another solution could be to use the line graph and then create a table with all of the responses and use the line graph to filter down the table, so you can see the responses in question. Just a thought.
Sorry I don't know what you mean, do you have an example?
Try dragging Respondent Number to rows (in front of the measures).
This will give you a line chart for each respondent. This may be too much though.
Like Wesley is showing, there is "overlapping" data so you can't see the other points underneath.
If you search the forums or Google for how to "jitter" points, this may be another option.
Yeah! That's also a great idea.