AnsweredAssumed Answered

Charting Expiration Dates

Question asked by TylerNelson on Dec 13, 2013
Latest reply on Jan 15, 2014 by philmodjunk

Title

Charting Expiration Dates

Post

     Hi!

     So my client wants a chart that he thinks is simple, but I'm racking my brain to build it in Filemaker. 

     I have a Projects (Films/TV shows) table and each Project some of the projects have "Options" with 2 expirations dates, one for the initial term and another for the extended term (generally 2-5 years). 

     The Client wants a stacked bar chart with the list of optioned Projects on the Vertical Axis (Easy) and a timeline on the horizontal axis extending over the course of say 4-5 years with bars that represent the lifetime of each project ending on the expiration date. 

     Can anyone suggest a calculation for the X-Asis data using the 2 expiration dates to plot the bars on the horizontal axis???

     I have a calculation field in Projects that calculates the number of days left in each option term. But if I chart that it won't be exactly linear... I know my client envisions the horizontal axis to include every month, but I don't know if that's possible.

     I'm basing the Graph in a globals table with 1 record and relating it to Projects (delimited data) with a Constant1 = BooleanField for Projects that have Options. Maybe this will require putting the graph in a different context...

     Thanks!

     Stephen

Outcomes