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!
1 of 1 people found this helpful
Thanks, Tracy. I used your suggestion and it works fine for a single field (column). However, all columns then follow that condition and are colorized according to the same parameters. I need to colorize with each column of data having separate parameters. Any ideas?