AnsweredAssumed Answered

Manually creating relationships with calculations.

Question asked by chris.t.merlini on Sep 23, 2013
Latest reply on Sep 24, 2013 by ch0c0halic

Hello FileMakers.


Please mind that this is my first post on this forum and I am not familiar with the culture of this forum.




So, to the problem I have.


I have a bunch of data points that I need correlated.

Since I am not at liberty to disclose the details of the objects, I will use an example.

I have many types of "Bacteria" for analysis. The table has "Growth Rate" of "Bacteria" over "Time (Hours)"

To make the example easier, all bacteria have been analized over the same period of time and there are no missing data points, therefore we can exclude error checking and special cases.


The picture below represents what I have currently.

I know this graph is wrong but this is what I can design to the best of my knowledge.

The "z_Correlation_n" is supposed to be a calculation where it's supposed to loo something along the line of this:

SUM ( ( OneRecordOfGrowthRateOfBacteriaA - AverageGrowthRateOfBacteriaA ) * ( OneRecordOfGrowthRateOfBacteriaB - AverageGrowthRateOfBacteriaB ) ) / SQRT ( SUM ( (OneRecordOfGrowthRateOfBacteriaA - AverageGrowthRateOfBacteriaA ) ^ 2 ) * SUM ( ( OneRecordOfGrowthRateOfBacteriaB - AverageGrowthRateOfBacteriaB ) ^ 2 ) ) NOTE: each record is incremented with time.


To be honest the math isn't really important. I ask anybody, "How do design the relationships to calculate with self relating data?"


If there are other things you would like to point out, please do so. Being criticized opens the path to improvements.


Screen Shot 2013-09-23 at 14.18.09 .png