Visualize Frequency Counts of Binary Dimensions

[spetushigxpa]

Hello,

I have multiple dimensions in each record with either a 'Yes' or a 'No' value and would like to display a frequency count when 'Yes' appears against a dimensions.

Example:

IndexNum	Reporter	Q1	Q2	Q3	Q4	Q5	Q6	...	Qn-1	Qn
0001	reporter A	Yes	No	Yes	No	Yes	Yes	...	No	No
0002	reporter B	No	Yes	Yes	Yes	Yes	Yes	...	Yes	Yes
0003	reporter B	No	No	Yes	Yes	No	Yes	...	No	Yes
0004	reporter C	Yes	No	No	No	Yes	Yes	...	No	Yes
0010	reporter A	N/A	Yes	No	N/A	No	Yes		N/A	Yes
...	Header 8

I would like to show a horizontal bar chart, where the x-axis has the dimensions: Q1 to Qn and the y-axis shows the counts of 'Yes' against each dimension. some kind of histogram of 'Yes' counts against the corresponding dimensions.

Thank you

Sokol

[marcus_sommer]

Please do not double-posting: Frequency counts of "binary" dimensions

[spetushigxpa]

Thought this would be relevant to both forums.

Can I include more than one forum when I post a question?

[marcus_sommer]

The most forums are not really separated from each other unless a few language- or profession specific ones. I think the intention by creating them was different but now they are just a kind of categorise. This means in the most cases it's not useful to repeat the posting in various forums and should there be a good reason (maybe within a language specific groupand in the general area) then it would be helpful to add in each one a link to other posting.

- Marcus

[spetushigxpa]

Got it, thank you for the clarification. Should I remove this one?

[marcus_sommer]

I think it's not necessary.