Anonymous
I am trying to create a chart from a question grid where 5 retailers were across the top and 18 attributes were down the side, and the respondent selected all the retailers that fit each attribute. So my data has one variable for each retailer-attribute combo (90 total) with a value of 1 if selected and zero if not selected. I am trying to create a horizontal bar chart where the attributes are the measures down the side and each bar is a retailer. Can you tell me the best way to do this?
robsmith
Sep 2, 2016
Do the variables have a nice naming convention, something like q{retailer}_{attribute}? e.g., q5_4 where 5 is the retailer and 4 is the attribute? Or is it just a straight v1...v90?
Naming convention is good – B3r#c# where r# is rating and c# is retailer. – Anonymous 9/2/2016 5:49:34 AM
robsmith
Sep 2, 2016
Okay, you'll need to use the var axis like this:
In the measures axis, your syntax would be something like this:
pctin(B3@{var}c1,1)
pctin(B3@{var}c2,1)
pctin(B3@{var}c3,1)
pctin(B3@{var}c4,1)
pctin(B3@{var}c5,1)
...
In the var axis, your syntax would be:
r1
r2
r3
r4
...
Tricky! Yes, that makes sense – Thanks! – Anonymous 9/2/2016 5:53:32 AM
Comments