I have a pie chart that is created based upon the percentage of red, yellow, and green items in my report. The chart looks well and it works fine. The fundamental issue is I cannot control the number of Red, Yellow, Green items. One day may have 2 red status items, no yellow status items, and 62 green status items (note: there are 64 total items). The next day may have 1 red status item, 1  yellow status item, and 62 green status items. Or all 64 items could be reporting a green status and 0 red, and yellow status items.

 

The problem I am having (that I am posting here for someone much smarter than me to give me the simple answer that I need) is that when the data does change, the red, yellow, green color settings for the previous day no longer reflects the new data. (This is only true if I have a new color added or a color is no longer needed, i.e, all green, or goes from red and green to red, yellow, and green.)

 

I hope I have explained this in a way that is easy to read without confusing anyone. Anyone who can provide some feedback on this issue would be greatly appreciated.

 

1) I only have one formula in here that gives the Red (R), Yellow (Y), and Green (G) of the items. If I use the highlighting feature on the formula todays_status, I can only compare it to R,Y, or G, which is the output of todays_status. It calculates this value for each individual item in the report.  Since this is not the information I based my actual pie chart on, I can't utilize this function correctly on this report.

 

2) The only other option it gives me is to base it on the percentage of total collectors (i.e, a running total field of all the green, red, and yellow items respectively). It will only allow me to compare it against a number. This is unacceptable because I am not sure if all the items will be green, or if only two of the items will be red and the remainder green, or any other possible combination. If I were to base my comparison on a number I'd be making an assumption about the items that may or may not be true, depending on the circumstances.

 

As I said, there has to be a better way to implement this, but I am unsure as to what that method is. ..