5 Replies Latest reply on Apr 27, 2017 12:45 PM by davyd Smith

# Working with Percentages

This is probably pretty simple but I am lost on how to do it.  I am working in Desktop version 9.3

I am crunching stats for animal shelters and rescues.

I have one number that I want to compare most of the time and the simple comparison on a bar chart of whole numbers works, for instance:

• Total Intake (all animals in the shelter that year)
• Total Positive outcomes (all animals adopted, transferred, returned to owner, etc)
• Total Negative outcomes (Animals dies in the shelter, stolen, missing, etc.)

So that’s easy enough and works well for looking at on or more organizations about the same size in intake.

But when comparing two organizations it can become a problem when one shelter brings in 10,000+ animals and another brings in 100.  The comparison is not clear because they deal with a much different volume of animals and bar charts when comparing 10 or 100 organizations it does not visualize well.

But I would like a bar chart to show percentages on things like this as well, for example:

• Total Intake 100%
• Total Positive outcomes 80%(Of Intake)
• Total Negative outcomes 20%(Of Intake)

OR

• Total Intake 100%
• Total Transfers from out of state 30%(Of Intake)

This helps compare the performance of a large and a small shelter side by side and how they are doing with one or more metrics on a percentage basis of total animals in their care.

I assume I need to create a calculated field or something.  I tried just using the “Percentage of” tool under the Analysis tab, bu that is not working right for me.  Maybe it is just something I am missing.

I tried to attach the whole TWB but it is 50 MB and aqpparently to large to upload to the forum.

• ###### 1. Re: Working with Percentages

Hard to say with the information provided what is the best course of action. Try a Quick Table Calculation % of Total. I assume you will have a field saying whether it's a +ve or -ve outcome and out of state flag. Play around with the 'Compute Using' of the quick table calculation if necessary to get the results you expect.

• ###### 2. Re: Working with Percentages

You could filter out some of unnecessary data and upload a smaller MB twbx!

• ###### 3. Re: Working with Percentages

Hey Prayson.  Thanks!  I uploaded the twb and excel source.

• ###### 4. Re: Working with Percentages

To do:

• Total Intake 100%
• Total Positive outcomes 80%(Of Intake)
• Total Negative outcomes 20%(Of Intake)

You could simply divide Measure Values with SUM(Total Intake):

You could also attempt another way to visualise your data: E.g.

1 of 1 people found this helpful
• ###### 5. Re: Working with Percentages

So I took so long to get back.  I think I got it!  Thank you!

Davyd