I have a straight table similar to above that I want to turn into a pie chart.
The Group column is derived from a calculated dimension that does an if statement on the difference between two dates.
The Count column is the expression, it's a simple count of rows.
I want to color the pie chart Red for the R rows, Yellow for the A rows and Green for the G rows but I can't figure out how to do it. Please can someone help?
I'm afraid I can't post my worksheet because it contains sensitive data.
