I have a pie chart that shows test results by three Risk Levels (High, Intermediate, and Optimal) for a particular physician. Then I have another pie chart that uses set analysis to show test results for the same three Risk Levels, but for all physicians located in the same state as the selected physician. In other words, I’m comparing one physician’s Risk Levels against all the other physicians in that state. This is working fine. The problem is, I would like the pie slices in both charts to be specific colors (High = Red, Intermediate = Yellow, Optimal = Green, default = Gray). I have the background color definition set to use the selected Risk Level value to set the color, and that works fine most of the time. However, if the selected physician does not have data for one of the Risk Levels, the second pie chart’s slice for that group gets the default color rather than the color it should get. I realize this is because that Risk Level is now excluded, since the selected physician doesn’t have any data for it. But obviously, the second pie has some way to distinguish the dimensions correctly, based on the set analysis expression. When there is data for that Risk Level for some physician in the state, the chart correctly displays the data and the Risk Level name in the legend. How can I get all the pie slices in the second chart to be the correct colors? What field or setting do I need to use in the background color expression, or is there another way? Setting the colors to match on the two pies is very important to my users. Please see the attached app. Any ideas on this are greatly appreciated!
