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!
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!
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?
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