Chart from question grid

0     4     Edited Sep 2, 2016 by 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?


Comments

0

Rob Smith 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?

0

Naming convention is good – B3r#c# where r# is rating and c# is retailer. – Anonymous 9/2/2016 5:49:34 AM

0

Rob Smith 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 
...
0

Tricky! Yes, that makes sense – Thanks! – Anonymous 9/2/2016 5:53:32 AM

Leave a Comment

Please sign in to leave a comment.