# Fact Sensor Measures

• 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.