1) Yes there is a limit. Some else asked about this in Report an Issue recently.
2) It would help to share both the details of your relationship and the calculation that you are using.
Yes, I tried to send you more pics but I could only upload one pic. The current table has, as I mentioned, 8031 rows all with the same case-id, logtag number and indices 1 - 8031. It is linked by case-id and logtag number to the related file. The related file has 8 indices that pinpoint times that need to be noted in the chart. The chart now displays a graph of all 8031 occurrences, but it seems to pick out only a couple of indices to match on. All indices in the related file are in the current file, the current file is in sequential order by index.
I will attach another picture of how I defined the calculation for matching on the index.
I still can't make sense of your data model. Your calculation refers to two table occurrences. Which is the occurrence for your layout and which your related table?
And the calculation returns the quoted text "NZ" if the values are not equal and a null string if they are? and yet the result is supposed to be a number and not text ???
Is the data source option for your chart "Current found set" or "related records"?
A look at your chart set up options would also be helpful.
Good question. I just copied my calculation from the one that had worked previously. I was trying to say "if the index from the current table matches the index on the related table, insert the icon associated with "NZ". I works on some but not all.
I changed the calculation to:
If (SEEDRLogData::index = FormHubData 12::Index_STOP1;SEEDRLogData::readings;"")
Every field referenced here is a number. It still only gives me two hits, but it puts the icon directly on the graph line (see attachment).
I don't see how that works at all. In FileMaker 13 on my WIndows system, I don't see any option for adding a "Y-series icon" by calculation or any other means.
You also haven't answered all of my questions about which table occurrence is which.
But you might find this info posted by TSGal over in report an issue relevant:
From page 415 of FileMaker Pro 13 Help, it says:
"A chart can display up to 2048 data points. If your data set contains more than 2048 records, FileMaker Pro charts a subset of the available data representing a uniform spread of the larger data set."
So part of the problem may be that the particular point you are trying to "mark" in this way simply isn't one of the "subset of available data representing a uniform spread of the larger data set".
Thank you - that is exactly what I was looking for because it explains what I have been seeing.