Counting colors

[#1]

Hi

I have a graph like this:

How can i count how many bars are Blue, Red and Green?

My expression is like this for Background color 

if (ABC='A',LIGHTRED() ,if (ABC='B',LIGHTBLUE(),if (ABC='C',LIGHTGREEN())))

Best regards

/Mats

Message was edited by: matshawk

[tresB]

That depends on how your expression decides on color. Please share a sample app.

[AbhijitBansode]

It all depends on your expression.

But if you have limited number of values in your dimension then something like below would help:

count({<ABC= {'A'}>}ABC)  -- # of LightRed bars

count({<ABC= {'B'}>}ABC)  -- # of LightBlue bars

[tresB]

Again, dimension members are needed. Anyway, try like this: take a straight table with similar dimension member and expression as : If( ABC='A', 'RED :'&Count(ABC), IF(ABC='B' , 'Blue :'&Count(ABC), If(ABC='C', 'Green :'&Count(ABC))).

Though i am not sure it would work. Best way could have been- sharing sample app. If you are worried about the data, you can always scramble it upload. See how to prepare for upload .

[#5]

Hi

I have come some way by doing like this:

My dimension is Machine_Beläggning of which are divided in some 'A', some 'B' and some 'C' machines

If i have an expression like this: if (ABC='A',1, count({<ABC= {'A'}>}ABC) ), i get one bar for each machine that is an 'A' machine. So far so good... The thing is that i don't want bars, just a number that are the sum of the 'A' machines, in this case 7.

Best regards

/Mats

[er_mohit]

if you want to count it then take three text object with equal sign write your condition

like this

=count(if (ABC='A',ABC))  //for 1st one text object

count(if (ABC='B',ABC)) //for LIGHTBLUE() for 2nd text obj

count(if (ABC='C',ABC)) // for LIGHTGREEN() (3rd text obj)

hope it helps

[tresB]

May be like this? take ABC as a dimension in a straight table and use expression: Count(ABC)

[stigchel]

Without a dimension you would need an aggagrate:

Aggr(Count(if(ABC='A',ABC)),Machine_Beläggning)

[#9]

Hi

I only want to count the ’A’s, ’B’s or ‘C’s that have values on them.

Does this make sense?

7 ‘A’s, 3 ‘B’s and 6 ‘C’s

/Mats

[tresB]

Then try the expression something like:

Count(If(not isnull(YourValueField) and YourValueField<>0, ABC)