![]() ![]() When downloaded as numbers the same responses would look like this: For example, when downloaded as labels survey responses might look like this: With most commercial survey systems you can download the data in a label format or a numeric format. This is one of the major “gotchas” for me, at least for larger surveys. You cannot combine text results with numeric results ![]() If you end up adding new questions to your survey or reorganizing how questions are categorized in your helper file will either need to regenerate the primary data source groups or manually edit them. ![]() Tableau will do it when you click a button, as it were, but it won’t update the list automatically. Tableau’s generation of the primary group is much like populating the members of a parameter with the members of a field. IF =”Things you Measure” then END You need to update the group members if you add new questions You can’t refer to a group in a calculated field, so something like this won’t be available: You cannot refer to the group in a calculated field There are several things that a join will give us that we can’t get with a blend. So, are there any shortcomings? Is this blend approach as good as being able to join the pivoted data with the helper file? Yes, there are shortcomings Isn’t this great? We didn’t have to go groping around for the right Question IDs and we didn’t have to alias anything. Right-Drag Value to Columns and select AVG(Value).Figure 11 - The Grouping group makes is easy to indicate which sets of related questions you want to examine. ![]()
0 Comments
Leave a Reply. |