100% stacked chart

[#1]

Hi,

I have the following data structure ...

and i'm trying to turn them into 100% stack chart in QV

i have attached my sample file and i hope some one is able to have a solution?

Thanks,
Nick

[prieper]

Am not quite clear, what do you want to achieve. Can you please give some more realistic names to your Dimensions/Attributes/Values. On the first glance it seems as if the datamodel behind is a bit strange.

Peter

[#3]

Hi Peter,

It's the result for a survey,

F1 = User friendly
F2 = Design
F3 = Training

and ranking is from scale of 1 to 3.

The data is already stored that way. if you open the qvw file, there's a pic to describe the data model excel needed to generate the 100% stacked chart.

but i'm trying to do it without having to modify the data structure itself, because it actually has other column link to it, it's not normalize for simplicity reason.

but you any solutions are welcome, as i'm thinking on how can i tweak the data structure i'm having.

Thanks,
Nick

[prieper]

But then you are missing the very first column, be it application-name or date of the poll or the like?

Peter

[#5]

yes, we have other columns like : zone, country, product .. etc.

but, for now, i'm trying to see if there's any way to create a 100% stack chart without those info for simplicity, like how we can do it in excel.

do you think that's possible?

Thanks,
Nick

[rwunderlich · Accepted solution]

See the attached for a possible solution.

I used CROSSTABLE to assign the the F1/F2/F3 values to each row which made creating the chart easier

I'm sure there are other solutions.

-Rob

[#7]

Hi Rob,

Thanks for the solution, it's exactly what i need.

You just introduced me CROSSTABLE and the following formula ...

=Count(Rank) / Count(TOTAL<Feature> Rank)

thank you very much for your help !

Nick