I would take a look at our great whitepaper on survey data:
Otherwise, we're going to need a packaged workbook to give you a more in-depth answer.
Yes, these are all easily accomplished.
(1) Assuming that your Pre-Q1 and Post-Q1 are separate dimensions, you first pivot the data so that they are as follows:
Respondent | Pivot Names | Pivot Values
R1 | Pre-Q1 | 2
R1 | Post-Q1 | 3
R2 | Pre-Q1 | 3
R2 | Post-Q1 | 1
You can then see the Pre-Q1 and Post-Q1 side-by-side after creating a group out of the Pivot Names column.
(2) Yes, this is accomplished by a single formula, zn([Response]), which turns any null values into 0.
I work in market research and would gladly help regarding survey data if you have any more questions.
I'll give this a try and reach out if I have any other questions. Thanks!!
BTW, please accept my answer as correct if it's worked out for you. I think there's a button for it somewhere?
So I have a situation where respondents aren't forced to answer a question therefore I have blanks that are skips however I still want to create a 0 bar for options that weren't selected. Do you have any input on this?
If you could provide an example workbook that'd be great.
Go to Analysis -> Table Layout -> Show Empty Columns (if bars are vertical) or Show Empty Rows (if bars are horizontal)
Not sure if you need a workbook for this but let me know if you do.
I already tried that. Didn't do anything for my viz. Since no one selected option D I assume that Tableau doesn't know it exists so has nothing to show.
I am working in another thread and looking at scaffolding to fix my option D issue.
For your help on pivoting the data. Does the same work for unpaired data? Say they took the Pre but not the Post or vice versa. Do I have to create two rows per respondent and just leave the second blank or just pivot the data and include what I have?