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
...	...	...	...	...	...	...	...	...	...	...

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]

Just transform your data with The Crosstable Load into a "normal" table which will create a dimension-column for your 'Q*' and one Yes/No measure-column and with both you could create your chart whereby the expression might be look like: count({< [measure-column] = {'Yes'}>} [measure-column]).

- Marcus

[Anonymous]

Hi Sokol,

Please find the below

Tab1:

CrossTable (Quarter, Status, 2)

LOAD IndexNum,

     Reporter,

     Q1,

     Q2,

     Q3,

     Q4,

     Q5,

     Q6

FROM

[..\Desktop\Book1.xlsx]

(ooxml, embedded labels, table is Sheet3);

and create a bar chart with Quarter as dimension and Count({<Status={'Yes'}>} Status) as expression. You will get the below result.