Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pie chart that is looking at waiting times. So, simply, bandings of 0-4, 4-8, 8-12, 12+. Colours are set but i would like the 12+ banding section to be green when it's less than 10% of all waiting times and red when more than 10%, how?
Can you sample file ?
Kevin, The first thing I would do is not use a Pie Chart. Studies have been done that show this chart is difficult to understand. Instead I would us e a stacked bar chart or just a regular bar chart. Then under your expression, you can expand it to show background color, There you can set something like
IF(sum(BANDING)>12,green())
A sample qvw would help but a possibility would be to use the the background color for your expression - in this ara you would code what you want the colors to be
File attached
I do not see any data loaded in the application - can you please reload, include the pie chart with your desired banding and re-attach - thanks
Sorry my mistake, try again
Try this. I updated the background color on the expression.
It looks like there are a total of 25 patients and 17 of them are in the 12+ category. The percent would need to be determined (17/25). which is 68% - If I understand correctly, this section of the pie (or the bar if you switch to a bar char) should be red? If the percent was less than 10% then this section of the pie (or bar) should be green?
Yes that's correct in what you're saying