Fact Sensor Measures

Last modified: Jul 17, 2018 @ 10:40

  • Average: The average value for the aggregation period.
  • Average %: The average percentage value for the aggregation period.
  • DateId: The ID used to connect to DimDate.
  • Datetime: The date and time of the measurement.
  • DeviceId: The ID of the device.
  • DeviceNetworkId: The ID of the device network.
  • Dimension: The dimension of the imported data.
  • End: The end value of the aggregation; for example, if the aggregation is one hour then this value will represent the last incoming value during that hour.
  • End %: The end percentage value of the aggregation; for example, if the aggregation is one hour then this value will represent the last incoming value during that hour.
  • Max: The maximum value of the aggregation; for example, if the aggregation is one hour then this value will represent the maximum incoming value during that hour.
  • Max %: The maximum percentage value of the aggregation; for example, if the aggregation is one hour then this value will represent the maximum incoming value during that hour.
  • Min: The minimum value of the aggregation; for example, if the aggregation is one hour then this value will represent the minimum incoming value during that hour.
  • Min %: The minimum percentage value of the aggregation; for example, if the aggregation is one hour then this value will represent the minimum incoming value during that hour.
  • NbrOfMeasurements: The number of measurements during each aggregation period.
  • Resolution: The chosen resolution for the aggregated values.
  • SensorId: The ID of the sensor that captured the measurement.
  • SensorMeasuresKey: The unique identifier for each row in the table.
  • Start: The start value of the aggregation; for example, if the aggregation is one hour then this value will represent the first incoming value during that hour.
  • Start %: The start percentage value of the aggregation; for example, if the aggregation is one hour then this value will represent the first incoming value during that hour.
  • TimeId: The time ID used to connect to DimTime.
  • Variance: The expectation of the squared deviation. This value is usually practical to use for cumulative values such as walk-in counters.
  • Variance %: The expectation percentage of the squared deviation. This value is usually practical to use for cumulative values such as walk-in counters.