chart help needed

[#1]

Hi,

I have data in the qvw. I have to show bar chart based on the due days.

if days > 0 = red color in bar chart

if days = 0 = green color

if days < 0 purple colour on bar chart for that date

one day should show one line

can anybody help.

[JonnyPoole · Accepted solution]

I switched the approach to count the IDs

You need 3 expressions each with their own background color

1st expression:  count(   if (  Duedays<0, ID))      ( background color:   green())

2nd expression:  count(   if (  Duedays>0, ID))      ( background color:   red())

3rd expression:  count(   if (  Duedays=0, ID))      ( background color:     rgb(196,178,214))

and change the style of the chart to stack

also use 'DueDate' as the dimension

[Anonymous]

somethin like this?

[#4]

Hi Jonathan,

Thanks for the help, yes that is what I want.

Thanks again.