How to filter a bar chart to count if a value contains a certain value

[#1]

In the following example:

A	B	C
1	2	1
2	1	1
3	1	2
3	4	1

How would I create a bar chart that displays A, B, C on the x axis. Then counts the '1's only

Thanks in advance!

Many thanks

[Anonymous · Accepted solution]

You could create 3 expressions with the calculation as follows

for A: count({<A = {1}>}A)

for B: count({<B= {1}>}B)

for C: count({<C = {1}>}C)

[#3]

Thanks Greeshma,

Would i use A, B. C as the dimension?

[Anonymous]

No need to add them as dimensions.

[sunny_talwar]

I think it might make sense to transpose the data using The Crosstable Load‌. Once you do that, you can use A, B, C (which will now be in a single field) as a dimension and Count() expression

[Anil_Babu_Samineni]

Yes, you can use like

ValueList('A','B','C')

[trdandamudi]

See if the attached helps....