When you look at this data, how do you tell which records are part of a one curve and not another?
The table "Curves" contains a field IDAnalysis which is the key of the table "Analysis". There is a relation between "Analysis" and "Curves" using IDAnalysis.
The table "Curves" contains also a IDcurve key that identifies the different curves.
To sum up, if you examined your data in a portal on this layout, you'd see one set of records with a common value in IDcurve that identify them as points in the same curve. A set of records that are points from a different curve will also appear, but with a different common value in the IDcurve field?
Note that x vs y plotting for even one curve will be problematic unless x increments in a consistent interval with no gaps due to limitations in how FileMaker charts such data. To plot two different curves, the x values will need to be the same for both series of y values also.
If you are using FileMaker 12 or newer, you can replace your List function with ExecuteSQL() function calls and use a WHERE clause to specify a particular value for IDCurve.
SELECT Y from \"YourTableNameHere\" WHERE IDCurve = ? Order By x " ;
"" ; ¶ ; Specify value for ID curve here )
Thank you Phil for the patience.
This is what i have in the table "Curves":
IDCurve IDAnalysis x1 x2 x3 x4 x5 y1 y2 y3 y4 y5
1 1 0 10 20 30 40 10 40 85 110 150
2 1 0 10 20 30 40 25 55 130 90 65
I can correctly plot the first curve, but not both at the same time.
Yes i'm using FileMaker Pro 13, but i have never used ExecuteSQL before so i need some more indication... should i put the SQL function into the "Specify Calculation" for the y values of the graph?
Thank you again
To chart multiple lines, you need to define multiple Y-Series.
Yes, you can put this function into the calculation dialog for each Y-Series that you define. The only difference from one expression to the next is the value you put in place of "Specify value for ID curve here".
Also, be sure that you have specified the "delimited data" data source option.
Is it possible to dynamically define the number of Y-Series? I.e. the analysis n°1 has two curves, the analysis n°2 has 4 curves, etc
It is not possible to change the number of series dynamically.