1 of 1 people found this helpful
A calculated field would need to be created, and then it would need to placed on the shape shelf on the Marks card. So the calculation would look similar to the following:
if avg([Rate])>=.92 then 'green'
elseif avg([Rate])>=.45 then 'yellow'
Hope this helps!
Thanks Tracy...that did help!