Hello! I have a table that tracks the distribution of labor hours for an operation. The table has three numeric fields that track each kind of labor hour - meetings, rework, and overhead. There are three fields because each operation has some hours devoted to each kind of labor hour.
I would like to compare the three fields against each other in a pie chart. For example, an ideal pie chart would have three wedges - one for meetings, one for rework, and one for overhead. How can I compare these three fields against each other? Picture is included below. Thanks!
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.
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)
Pie Chart From Fields
If you need assistance implementing this solution feel free to contact me off-world using the information in my profile: