Hi John,

This can be done by first creating a calculated field similar to the following:

if sum([Value])<90 then 'red'

elseif sum([Value])>103 then 'green'

else 'yellow' end

Change the mark type on your view to Bar. Then, place this calculation on the color shelf and if desired the sum(Value) on the label shelf. Then, place Number of Records on the size shelf. Click in the upper right of the size legend and select Edit Sizes... Then, drag the slider to the far right so that all the bars are the same length. Then, edit the colors in your color legend.

Hope this helps!

-Tracy