You'd need a data series of two values--one value would be the fraction of total hours completed (HoursCompleted / TotalHoursRequired ) and the second would be the remaining hours: TotalHoursRequired - ( HoursCompleted / TotalHoursRequired )
A calculation field that puts these two values in a list, should work as the data series, I think (haven't tested this):
List (HoursCompleted / TotalHoursRequired ; TotalHoursRequired - ( HoursCompleted / TotalHoursRequired ) )
Thanks for that answer - but it is a bit over my head. I guess what I was trying to achieve is more complex than I first thought.
What I am describing would use the "Current data (Delimitted data ) " option in the "use data from" drop down. (The delimitted data, would be your calculation field that uses the List function.)
Thanks again. I am a novice at this but am learnign as I go along. I have not had call to use 'value lists'.
I have just got my head around using Filemaker Pro Advanced Server, and thought a pie chart would be a good addittion to my training db.
I have created a new test db with 1 table and the 2 fields (HoursCompleted and HoursRequired) for me to try to figure out 'data series' and 'value lists'
Thanks again for your help
Would you like a commission ??????
Not necessary, If this is all you need. I've been plowing through the "Monday back log" and haven't had time to play with this Idea. I've been making a suggestion based one previous projects and something that I recently read in the FileMaker training series Manual. Let me play with the idea in a demo file and upload it in my next post for you to take closer look at and so that I can confirm to my own satisfaction that this idea will really work like I think it will.
OK, after a little playing around, I'm not only satisfied that the concept works, but that it can be simplified.
- Enter Layout Mode
- Use the Chart tool to draw a square on your layout for your pie chart.
- Select these options:
In "Use Data From", select Current Record (Delimitted Data)
For Label data, select the calcultion option and enter and expression such as this: List ( "Hours Completed" ; "Remainder" )
For the value data, enter this expression: List ( YourTable::HoursCompleted ; YourTable::TotalHoursRequired - YourTable::HoursCompleted )
- Just make sure the order to your lables matches the order to your series of values in the value data so that the correct values get the correct labels in the pie chart.
- Since you only have two sections to the pie chart, you can probably click Format Chart, select Legend and clear the legend check box.
- Now enter browse mode and test.
Note that in this version there is no special calculation field. I've replaced it with a simplified calculation that I have entered as part of the Chart's set up information instead.
Thankyou so much for that. I have downloaded it and it looks so tidy. I really do appriciate your effort.
I have been running this in my actual db and it is perfect - only blip seems to be when the HoursCompleted field is blank (no hours yet recorded) the chart sees this as 100% complete with 0 % remaining.
You can either set the field to auto-enter a zero or modify your calculation to read:
List ( YourTable::HoursCompleted + 0 ; YourTable::TotalHoursRequired - YourTable::HoursCompleted )