4 Replies Latest reply on Oct 15, 2013 8:35 AM by Ramon Martinez

# harvey Ball  / Proportion shape- anyone know how to update?

I want to use the proporation harvey ball shape - to show a maturity level- it should be based on % of maturity on a scale. So if you are 50% mature- its 1/2 of the proportional "ball". 1/2 of the proportion is filled. What is the easiest way to do this?

See attached

• ###### 1. Re: harvey Ball  / Proportion shape- anyone know how to update?

Mathew,

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"

ELSE "hb100"

END

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.

best,

Ramon

• ###### 2. Re: harvey Ball  / Proportion shape- anyone know how to update?

Hi Matthew,

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. ...

Jim

• ###### 3. Re: harvey Ball  / Proportion shape- anyone know how to update?

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.

Jim

• ###### 4. Re: harvey Ball  / Proportion shape- anyone know how to update?

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.

Ramon