6 Replies Latest reply on Jan 19, 2015 11:06 AM by psijmons

    Record selection for statistic calculations

    psijmons

      I am using the statistical functions for Average, St Dev, etc. on a set of related records.

      The user gets the option to exclude a record when it is an outlier and should not be included for the average calc., but the data has to remain in the set.

       

      In the attached ERD, there is a connection based on the presence or absence of this marker.

      However, this indeed does change the average, but it is not corrected for a reduced number of records to base the average on.

       

      I do want to keep the raw data and statistical data in separate tables as I expect a very high number of raw data records.

      Is there a better approach to this?

       

      Any suggestions appreciated as I am stuck on this one.

      Peter.