advanced bar chart

[Anonymous]

Hi everyone,

i want to calculate attendence of an employee for a month ,with Weekname as my dimension and his sum(attendance) as  expression , but the problem is i want to show all the employees who are having attendance less than 3 days for that particular week as below the axes..just like when we are plotting graph .

thanks in advance

[Anonymous]

All you need to do is to make the result negative if the attendance <=3.  For example:

if(sum(Attendance)>3, sum(Attendance), -sum(Attendance))

[ramoncova06]

see if this is what you are looking for

sum({< employee= {"$(=sum(attendance) < 3)"}>}attendance)

[Anonymous]

i want to show color in green and red

if(sum(sales)>15, sum(sales), Green(),

if(sum(sales)<15,-sum(sales),blue()))

this expression is not working pls help

[Anonymous]

To define color, you have to use "Background Color" expression, not the "main" expression itself which stays as is..  Click on the "+" sign at the expression name to see it.  The color background expression will be:

if(sum(sales)>15, green(), blue())

[Anonymous]

i dont want the minus signs on red bars , what to do ??

[maxgro]

try to hide the negative numbers with text color (replace column(1) if needed with your exp)

if(column(1)<=0,argb(0,0,0,0),black())

[Anonymous]

I'm not sure if it is possible.  In general, I'd rather use a clearer presentation.  Instead of showing the <=15 sales below the axes, I'd use a "normal" expression

sum(Sales)

But I'd add a reference line =15.  So, the lower numbers will be at or below the reference line.  In my example here the ref line is 100:

[Anonymous]

i used the same expression i see no values on red bars ,, and could you please why you used column there ,, wht was the logic ?

[Anonymous]

To get rid of the minus for the bars below the line add another expression of say Sum (Value)  and for it untick Bar and tick Value in Data Points

Rough mock up qvw attached.