Just to be sure I understand your request, would each fish line have it's own line (Y- series) on the chart? Or do you want to chart an aggregate value such as a sum or average that combines data from more than one fish line into a single charted line?
Both are possible.
The best would be to have each fish line have its own y-series on the chart. Would there be a way to select only certain lines at once though?
The number of lines charted would be static, but the Fish Line selected for each Y-series could be user selectable.
Are you using FileMaker 13?
Have you used SQL before?
Have you used ExecuteSQL before?
I'm thinking in terms of delimited data charting using a set of ExecuteSQL() queries for each Y-series, with a WHERE clause that references a global field to select for specific fish lines. You can then select a fish line in each of the global fields in order to chart them.
I am using FileMaker 13.
I have never used SQL or ExecuteSQL before, but that sounds like exactly what I would like to do.
If you've never used SQL, however, this becomes a pretty steep learning curve that can be difficult to scale via a Forum Thread.
Let's start with a Non-SQL approach and see if that will work:
Inventory::StockNumber identifies the FIshLine and You one that is identified as "1" and another identified as "2". This not the final version--that will allow user selecting fish lines, but it can be modified to do that once it works for you.
Define a calculation Field, cChartLine1, as:
If ( StockNumber = 1 ; NumberOfFish )
Define cChartLine2 as:
If ( StockNumber = 2 ; NumberOfFish )
define sCL1 as a summary field that computes the total of cChartLine1. Define sCL2 to total cChartLine2
Select the two summary fields as different Y-Series. Specify a data source option of "found set" , Summarized data.
Sort your records by the Date of Entry field.
If that works, we can substitute global fields for the literal "1" and "2" values in the above If functions to make them user selectable.
Would I put these new calculation fields in the "survival" table? or in the actual "inventory" table? The reason I ask, is we could have as many as 2000 lines at the same time, and we do not track the survival of all lines, just a subet.