Color change for bar graph

[#1]

Hi All,

I have attached the screen shots because i cannot copy the QVW file.

Dimension : =if(IsNum([Turnaround Time Network Days]), IF([Turnaround Time Network Days]>15, '16 + ', [Turnaround Time Network Days]),'Missing Dates')

Fact : Count([Turnaround Time RAG])

Colors of the bars should be GREEN AMBER and RED based on condition.

Condition : if ([Turnaround Time Network Days])>7, Red()

                     if ([Turnaround Time Network Days])<=3, Green()

                     if ([Turnaround Time Network Days])<=7, Amber()

I got the colors but the problem is if [Turnaround Time Network Days]>15 i have grouped into '16+' i want this bar to be in RED(). I am not able to do it. Please help me with this.

Check the screen shots.

Thanks & Regards,

Keerthi

[sanketkhunte]

Sorry.. I am not getting your exact requirement. Can you put it into other words ?

Thanks
Sanket

[#3]

I am getting the colors for bar graph. But when the dimension is '16+' the color should be red() but i am not getting.

Please check the screen shot chart, where the color of '16+' dimension is black. I want it to be in red()

Hope this helps in understanding requirement.

Regards,

keerthi

[sujeetsingh]

plz give a sample

[#5]

Hi Keerthi,

Try this in condition:

if ([Turnaround Time Network Days])<=3, Green(),

if ([Turnaround Time Network Days])<=7, Amber(), Red()))

[#6]

there are missing dates as dimension i dont want that to be in red. I am attaching the QVW.

[#7]

Hi All ,

I have attached thw QVW. Please click on the button to enable the chart.

I want 0 to 3 in green color, 3 to 7 in amber() and 8 to 16+ in red. remaining missing dates in Black.

Thanks & Reagrds,

keerthi

[#8]

I have attached the sample

[sanketkhunte]

Keerthi,

I could see below result.. if you require this let me know i will provide you expression

[MayilVahanan]

Hi

Try like this

Expression -> click the '+' sign -> background color

IF([Turnaround Time Network Days] < 3, Green(),

if([Turnaround Time Network Days] < 7, Yellow(),  // instead of yellow, use RGB for amber

if([Turnaround Time Network Days] < 16, red(), Black())))

Edit:

Result is  like below