Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
somethin like this?
Hi Jonathan,
Thanks for the help, yes that is what I want.
Thanks again.