I edit your workbook to implement what Harvey Ball.
I just create a calculated field "HarveyBall" with formula:
IF SUM([%])<=0.25 Then "hb25"
ELSEIF SUM([%])<=0.50 Then "hb50"
ELSEIF SUM([%])<=0.75 Then "hb75"
I use the measure % of your data set but you can use orther. This is just to communicate the concept
I use the calculated field in shapes and assigned the correct harvey ball to every value.
Check it out and let me know if this solve your problem.
HaveyBall.twbx.zip 23.8 KB
You can use pie charts.
Pie charts need calculated fields: Color of the slices and Size / Angle of the slices. Since you only have one field %, create another calculated field 1 - %. Then drag Measure Names to the Color Button and Measure Values to the Angle Button.
To change the colors, select Edit Colors from the color legend. Then choose a color palette or double-click on the color box to bring up a selection palette (that includes white and black).
If you use white for one of the slices, you'll also need to add a black border. Click the Color button > Effects > Border ...
The resolution is a bit low with the border and black / white. Two different colors (w/o a border) may work better. ...
HaveyBall_jimw.twbx.zip 22.4 KB
Looks like Ramon and I were typing simultaneously . Hi Ramon!
I'm not familiar with Havey Ball symbols---if they are quantized to 0%, 25%, 50%, 75%, 100% then I think Ramon's suggestion is better. You could still use a pie chart, but you'd have to do the binning anyway, and for this application the resolution on the shape images is better than the pie cart.
Hi Jim! I just try to put it in a simpler way, usually it is enough to present those five states 0%, 25%, 50%,75% and 100%
Your solution is more precise and very good.