Comparing Multiple Fields in One Pie Chart
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 ar...
Forum Discussion
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)
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)