Display a specific symbol based on a condition

Display a specific symbol based on a condition

I am trying to display a specific symbol based on a condition in a field.

I want to display a green dot where the average rate for a metric is 92% or above, a yellow triangle where the average rate is 45%-91.9%, and a red triangle when the average rate is <45 nbsp="" span="">

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:

used DataSource Sample SuperStore Data

Create Calculated Filed : Total Sales

if sum([Sales])>=1000000 then 'green'

elseif sum([Sales])>=600000 then 'yellow'

else 'red'

end