Need help prepping your survey data? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Great video! My survey data has been cleaned and transformed, working great for all my charts etc. I have used Steve Wexler's LOD trick (just as you did in this video) to turn any question into a demographic (useful since I already unpivoted all my data and that is okay). It looks like this: {FIXED [Response ID]: MAX(IF [Question #]=9 then [Answers] END)} When I filter by Question and am browsing questions and answers, the charts only show applicable data based on respondents who answered. However, when I use LOD to view on the question, the chart adds an additional Null value bar for all the respondents whom the answer did not apply to (this is based on skip logic in the survey, not that these people did not answer the question). How can I avoid this? I would like my LOD charts to look the same as when I view my q&as. Thank you!
There is a good chance it has to do with the data source type. Some data sources (like Excel) support pivots. Some like SQL databases don't. If this approach doesn't work, maybe preparing the survey data in Tableau Prep would work better? (ruclips.net/video/ItXEFRW1RZc/видео.html)
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Need help prepping your survey data? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
Hey Eric! This was extremely helpful. Thank you for sharing!
Yes! I'm so glad you found it and found it helpful. Thank you Adrianna!
Very helpful video. Thank you! But it is not clear how to write Respondent Count Calculation Field?
Thanks! If you jump to 14:57 you can see the formula
Great video! My survey data has been cleaned and transformed, working great for all my charts etc.
I have used Steve Wexler's LOD trick (just as you did in this video) to turn any question into a demographic (useful since I already unpivoted all my data and that is okay). It looks like this:
{FIXED [Response ID]: MAX(IF [Question #]=9 then [Answers] END)}
When I filter by Question and am browsing questions and answers, the charts only show applicable data based on respondents who answered. However, when I use LOD to view on the question, the chart adds an additional Null value bar for all the respondents whom the answer did not apply to (this is based on skip logic in the survey, not that these people did not answer the question).
How can I avoid this? I would like my LOD charts to look the same as when I view my q&as.
Thank you!
Hi Joud, so great to hear this helped! What happens if you exclude respondents where their ID = Null? Does that have unintended consequences?
Why pivot option does not show for me? Any idea?
There is a good chance it has to do with the data source type. Some data sources (like Excel) support pivots. Some like SQL databases don't. If this approach doesn't work, maybe preparing the survey data in Tableau Prep would work better? (ruclips.net/video/ItXEFRW1RZc/видео.html)