Comparing Multiple Fields in One Pie Chart

In order to compare values in a pie chart they need to be in the same field, with some sorting (meetings, rework, overhead) to put them in the appropriate series.

Here it looks like you have 2 options.

Option 1: (My recommendation)
Make those hour entries as a child table.
you would basically have 3 child records (meetings, rework, overhead)
With two fields; Type and Amount of Hours.

Then you can create the report easily. 
This also makes it possible to add more options down the road.  it also makes it possible so you can have multiple entries of the same type, without having to edit or change old records. 
overall its a much cleaner option.

Option 2:
Summarize the Data to some parent record, and use some percent formula fields to divide the total, by each individual amount, then convert back to a number, then run the report.  (Its nasty, and not clean or expandable)

Thanks for your reply, Matthew.  The only qualm I have about Option 1 is that the user has to create 3 records instead of one (i.e. my employees have to go into QuickBase and fill out 3 short forms rather than one slightly longer form).  Is it possible to create these three child records automatically when one parent record is created?

If they are doing it on a computer and not a phone, you can make that child table editable so it basically appears as a grid, and they can easily add all 3 records at once.

Let me know if you need more details on how to do that.

Yes, when you are creating the form, you can have the child table (embedded table) automatically be in grid edit mode.  

See attached, It basically makes it all one form, but give you the expansion and reporting you need.

Thanks Matthew, that makes sense. 

Here is a demo which you can add your own data to:

Pie Chart From Fields
https://haversineconsulting.quickbase.com/db/bmnu98a9f?a=td

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=567

If you need assistance implementing this solution feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt

Hi Danimal, thanks so much for your help! Works like a charm.  You're a lifesaver!