This content has been marked as final. Show 3 replies
I'd like to create a pie chart out of the following list (see illustration 1) - A pie chart that gives me how many Sites are in red, yellow and green dots out of the total 27 sites in a given month. (red means NULL or no data, yellow means have data, and green means good data).
The challenge here is that the red-dots items below are actually from the "history" view, which means they are NOT really existing when I want to see the result of a specific month. Therefore, when I try creating the pie chart, the total of the sites changes according to how many sites have data (yellow or green dots) in that particular month (see illustration 2).
Meaning I want a base of the pie chart with the total Site number = 27 (data from all registered entries/ fixed/ history view), also, showing me the portion of yellow and green dots in the relationship of the total sites (data from a particular entry/ specific monthly/ current view).
Could anyone please kindly guide me here? Thanks a lot!