How are the start and stop dates recorded? Are start and stop dates entered in the same field of different records or does each portal record record a start and a stop date?
What exactly do you want to see in your chart as your "time line"? (Charts are still rather primitive in FileMaker so it depends on what you want as to whether or not FileMaker can do it.)
Each task is a record, each record has a start and stop date as a seprate field.
What the protal looks like.
Start Date Stop Date March 6 2012 May 20 2012
Just want to show the span between the dates. Like a gant chart.
You can't do an actual gant chart, but you may be able to get close.
Do you want a bar chart with a bar for each record where the length of the bar = the number of days from the beginning of the project (the earliest start date) to the end date in that record?
Do you have FileMaker 11 or 12?
Close is as good as I need for now, thank you! And yes a bar with each bar showing the days between start and end for each record.
I am running FM 12.
I'm guessing that you want a horizontal bar chart for this...
What I am about to suggest works in 11 and should also work in 12. I'm still learning the changes in 12 so we may find some differences in where things are located in chart setup and how they are named in version 12...
For the vertical X axis, specify a field that is unique to each record in your related table of portal records. This might be a task name field or some such.
For the horizontal Y axis, specify a calculation as Portal Table::Enddate - Min ( Portal Table::Startdate ) // use your table ocurrence and field names.
Then select "related records" in the "Use Data from" drop down.
In Filemaker 12, there's a way to chart 2 values on the same bar. That gives you the option to use
Min ( Portal Table::Startdate ) - Portal table::StartDate
as the first value and Portal table::endDate - PortalTable::StartDate as the second value.
I haven't set up such a chart yet myself, but it might serve as an even closer approximation of your gant chart here.
PS. you may need to specify a sort order in the relationship to the portal's table if you don't have all your records correctly entered in the order you want for your chart.
In 12 you can have lots of what they call series for the X horizontal in a horizontal chart. Is this what you are talking about for the second. And I dont understand why you did a Min(Startdate)-Startdate. This gives you a 0 right? I understand the EndDate - StartDate giving you the # of days between start and finish. Is the Min suposed to bring the bar off of the 0 line?
Thank you for your help. So far I have the chart getting the information from the related table, and it gives me the number of days that each project will take. Can I make it so that it will show off of the bar a number of days from curent date to start date and a bar showing the number of days in the project?
I dont understand why you did a Min(Startdate)-Startdate. This gives you a 0 right?
I didin't use Min(Startdate)-Startdate, I used Startdate - Min(PortalTable::Startdate) (but I accidentally got the terms reversed). Min(PortalTable::Startdate) returns the earliest start date of all the related records in your portal. that will only be zero for the first related record. startdate - Min(PortalTable::Startdate) should represent the elapsed time from the beginning of your project to the start date of each related record.
In 12, the barchart option I'm thinking of is called "stacked bar". And yes, you would define two X-series.