Create a bar chart group by column

[#1]

Worker	Period	A	B	C	D
1	201601	1	1	0	0
2	201601	1	0	1	0
3	201601	0	0	0	0
4	201601	0	0	1	1
1	201602	1	1	1	0
2	201602	1	1	0	0
3	201603	1	1	1	0
4	201604	0	0	0	0

The table above is a simplified sample of the database that i'm using.

I would like to create a bar chart that shows the sum of workers who are using, A, B, C and D.

Could someone tell me the best way to handle this problem?

[shraddha_g]

Workers using A:

Count({<A = {'1'}>}Worker)

Similarly for others

[#3]

I would like to create a Bar chart with as dimension A, B, D and count(Worker) as measure.

[vinieme12 · Accepted solution]

Script:

CrossTable(USING,Value,2)

LOAD * INLINE [

Worker,Period,A,B,C,D

1,201601,1,1,0,0

2,201601,1,0,1,0

3,201601,0,0,0,0

4,201601,0,0,1,1

1,201602,1,1,1,0

2,201602,1,1,0,0

3,201603,1,1,1,0

4,201604,0,0,0,0

];

Grouped chart:

Dimensions: Period, USING

Expression Sum(Value)

Stacked Chart

[vinieme12]

Try with

Dimension as

USING

and

Expression as

Count(Worker)

[shraddha_g]

Try:

Dimension : Valuelist('A','B','C')

Measure:

Pick(wildmatch(Valuelist('A','B','C'),'A','B','C'),

Count({<A = {'1'}>}Worker),

Count({<B = {'1'}>}Worker),

Count({<C = {'1'}>}Worker)

)