Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks Greeshma,
Would i use A, B. C as the dimension?
No need to add them as dimensions.
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
Yes, you can use like
ValueList('A','B','C')
See if the attached helps....