Averager

The Averager is used to take the average value of a device field over multiple days. It was built so that the /wiki/spaces/PS/pages/21622486study could have feedback based on average weekly step count. A unique feature of the Averager is that the number of days it averages is based on the encounter window of the User Event it is attached to.


  • Setup

    • Source field: The source and associated field to be averaged.
    • Min value count: The minimum number of data points needed in order for the average to be considered valid. If left null there will be no minimum number of values needed for the average to be considered valid.
    • Min Acceptable value: the minimum value that a value needs to be in order for it to be considered valid. Any value lower than this will be considered invalid and excluded from the average calculation. If left null there will be no minimum for a value to be valid.
    • Max Acceptable value: the maximum value that a value needs to be in order for it to be considered valid. Any value greater than this will be considered invalid and excluded from the average calculation. If left null there will be no maximum for a value to be valid.
    • Selection method: Which value(s) from each day should be included in the average.
      • Daily minimum value: The minimum value from each day of the encounter window will be used in the average calculation.
      • Daily maximum value: The maximum value from each day of the encounter window will be used in the average calculation.
      • Daily first value: The first value from each day of the encounter window will be used in the average calculation.
      • Daily last value: The last value from each day of the encounter window will be used in the average calculation.
      • All daily values: Every value from each day of the encounter window will be used in the average calculation (doesn't really make sense for step count but could potentially be used for something like weight).
  • Data fields

    • is_valid: Is the calculated average considered valid based on the Min value count.
    • average: The average calculated based on the above setup.
    • minimum: The minimum value included in the average.
    • maximum: The maximum value included in the average.
    • number_of_values: The number of values included in the average.
    • values: A comma separated list of the values included in the average.
    • number_of_excluded_values: The number of values that were excluded from being used in the calculation of the average based on Min/Max acceptable value.
    • excluded_values: A comma separated list of the values that were excluded from being used in the calculation of the average based on Min/Max acceptable value.