Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That depends on how your expression decides on color. Please share a sample app.
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
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 .
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
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
May be like this? take ABC as a dimension in a straight table and use expression: Count(ABC)
Without a dimension you would need an aggagrate:
Aggr(Count(if(ABC='A',ABC)),Machine_Beläggning)
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
Then try the expression something like:
Count(If(not isnull(YourValueField) and YourValueField<>0, ABC)