Appendix B – Metrics Definition

Format: [Timestamp, Value]

Description: Live output via websocket (pulsar)

Update Frequency: Event Trigger

Aggregation: N/A

Description: The sum of the values

Formula: 

Sum = SUM(value1, [value2], ...)

Description: The cumulative sum of the values

Formula: 

Cumulative Sum = (SUM(value1), SUM(value1, value2), ...)

Description: The sum of the values divided by the number of values

Formula:

Avg = [Summation of all values / Count of values] in the set

Description: The smallest numeric value in a range of values

Formula:

Min = MIN(value1, [value2], ...)

Description: The largest numeric value in a range of values

Formula:

Max = MAX(value1, [value2], ...)

Description: Aggregation of minute data for every 15 minutes

Aggregation Frequency: Data being roll up to 15 minutes on the fly during query

Store in Server? Yes, 1 minute data is only store for 40 days.

Formula:

15-min Aggregation = Summation of minute values within 15 minutes

Description: Directly from hourly data table

Aggregation Frequency: On the fly ingested

Store in Server? Yes, 2.5 year retention.

Formula:

Hourly Aggregation = Summation of minute values within 60 minutes

Description: Aggregation of hourly aggregated data within operating hours or outside operating hours of the selected date

Aggregation Frequency: Data being roll up to daily on the fly during query

Store in Server? Yes, 1 hour data only store for 2.5 years retention.

Formula: 

Daily Aggregation = (Summation of hourly aggregated values of the selected hours) of the selected date

Description: Aggregation of hourly aggregated data within operating hours or outside operating hours of the selected week(s)

Aggregation Frequency: Data being roll up to daily on the fly during query

Store in Server? Yes, hourly data only store for 2.5 years.

Formula:

Weekly Aggregation = (Summation of hourly aggregated values of the selected hours) of the selected week(s)

Description: Aggregation of hourly aggregated data within operating hours or outside operating hours of the selected weeks

Aggregation Frequency: Data being roll up to monthly on the fly during query

Store in Server? Yes, hourly data only store for 2.5 years.

Formula:

Monthly Aggregation = (Summation of hourly aggregated values of the selected hours) of the selected month(s)

Description: Aggregation of hourly aggregated data within operating hours or outside operating hours of the selected quarter(s).

Aggregation Frequency: Data being roll up to quarterly on the fly during query

Store in Server? Yes, hourly data only store for 2.5 years

Formula:

Quarterly Aggregation = (Summation of hourly aggregated values of the selected hours) of the selected quarter(s)

Description: Aggregation of hourly aggregated data within operating hours or outside operating hours of the selected year(s)

Aggregation Frequency: Data being roll up to yearly on the fly during query

Store in Server? Yes, hourly data only store for 2.5 years.

Formula:

Yearly Aggregation = (Summation of hourly aggregated values of the selected hours) of the selected year(s)

Output Type
Timestamp

Data Format
Hour_Time_Period   e.g. 13 (1:00pm - 2:00pm)

Output Type
Timestamp

Data Format
Date_Period   e.g. 13 Mar 2024

Output Type
Live, Timestamp, Time_Range

Data Format
Count (integer, int(32))

Output Type
Live, Timestamp, Time_Range

Data Format
Count (integer, int(32))

If PFC01 > PFC02, then SFC03 = [ (PFC01 - PFC02) / PFC01] * 100
Else if PFC02 ≥ PFC01, then SFC03 = [ (PFC02 - PFC01) / PFC02] * 100

Output Type
Live, Timestamp, Time_Range

Data Format
Percentage (decimal(0), float)

Output Type
Live, Timestamp, Time_Range

Data Format
Count (integer, int(32))

SFC04_T1
Definition: Total Traffic (Warning Level)
Threshold Value: 100

SFC04_T2
Definition: Total Traffic (Critical Level)
Threshold Value: 500

SFC04_T3
Definition: Reset Alert
Threshold Value: 50

Output Type
Live, Timestamp, Time_Range

Data Format
Count (integer, int(32))

PFC05_T1
Definition: Toilet Usage Warning
Threshold Value: 70

PFC05_T2
Definition: Toilet Usage Alert
Threshold Value: 90

Output Type
Live, Timestamp, Time_Range

Data Format
Count (integer, int(32))

The number of visitors in an area at any given time within the predefined operating hour.

Output Type

Live, Timestamp, Time_Range

Data Format

Count(integer, int(32))

PSO05 - Smart Occupancy
PSO08 - Heatmap Space Occupancy

The number of visitors in an area against the area's maximum capacity at any given time within the predefined operating hour.

SSO02 indicates the Occupancy vs. Capacity rate by comparing the occupancy (PSO05 or PSO08) for the selected count_mode of the selected aggregation_level with the maximum capacity (PSO05_T2 or PSO08_T2 respectively)

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

The number of visitors in an area at any given time (with error correction applied) within the predefined operating hour.

PSO05 indicates the Human Occupancy based on the differences between the summation of PFC01 - Footfall Count IN and summation of PFC02 - Footfall Count OUT with Error Correction for the selected Count_Mode of the selected Time_Aggregation_Level

There are 2 types of error correction, smart 1 and smart 2
Smart 1: Correction based on last 14 days data calculation (system auto correct) 
Smart 2: User set the expiry time for the count. If the count is different after the expiry time, it will be expired and corrected

PSO05 = [Summation of PFC01 - Summation of PFC02] + Error Correction

Smart 1 Error Correction = System auto correct based on last 14 days data
Smart 2 Error Correction = Add an out count when the in count is expired

Output Type

Live, Timestamp, Time_Range

Data Format

Count(integer, int(32))

PSO05_T1
Definition: Target Occupancy
Threshold Value: 8

PSO05_T2
Definition: Maximum Capacity
Threshold Value: 10

PSO05_T3
Definition: Occupied
Threshold Value: 1

Raw Log

RL07 - cameraSerial | timestamp | FloorplanID | RoiID | CombinedObjectTypeID | Date

Duration of occupancy for a specific heatmap grid, indicated using the defined colour scale.

PSO08 indicates the number of people occupying the area of interest for the specific period of time, based on the summation of utilized duration of the selected grid(s) within the area polygon.

PSO08 = [Summation of 15-min-average-occupany / No. of 15-min period] 

Output Type

Live, Timestamp, Time_Range

Data Format

Count(integer, int(32))

PSO08_T1
Definition: Heatmap Occupancy Target Capacity
Threshold Value: 8

PSO08_T2
Definition: Heatmap Occupancy Maximum Capacity
Threshold Value: 10

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Total duration of time where an area is being occupied within the predefined operating hour.

Output Type

Live, Timestamp, Time_Range

Data Format

Duration in seconds (integer, int(32))

Percentage of time where area is being occupied against the duration of the predefined operating hour.

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Duration of time on average where an area is being occupied within the predefined operating hour.

Output Type

Live, Timestamp, Time_Range

Data Format

Duration (int, int(32))

Percentage of time where the space occupied rate exceeds the predefined maximum space occupied rate.

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Percentage of time within the operating hour where occupancy is within the predefined target range.

SSU07 = [Summation of time where (PSO05 ≥ X and PSO05 ≤ Y) / SSU02] * 100%

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Output Type

Live, Timestamp, Time_Range

Data Format

Percentage (decimal, float(32))

Raw Log
RL03 - WiFi Raw Log
cameraSerial | Mac | Timestamp | Signal | Type

PFC01 - Footfall Count IN

Output Type

Timestamp, Time_Range

Data Format

Count (integer, int(32))

WA02 = [PFC01/(PFC01 + PWA01)]*100%

(PFC01 includes only Count Mode = Visitor) 

Output Type

Timestamp, Time_Range

Data Format

Percentage (decimal, decimal(2))

Raw Log
RL03 - WiFi Raw Log
cameraSerial | Mac | Timestamp | Signal | Type

PWA03 = SUM(visitor out date time - visitor in date time) / (No. of MAC address detected)

Output Type

Timestamp, Time_Range

Data Format

Time (00h 00m, 00m 00s)

Raw Log
RL03 - WiFi Raw Log
cameraSerial | Mac | Timestamp | Signal | Type

SWA04 = [Count Distinct (Last 14 days Matching Mac) / Count Distinct (Mac of the selected date) ] * 100%

Output Type

Timestamp, Time_Range

Data Format

Percentage(decimal, decimal(2))

Raw Log
RL03 - WiFi Raw Log
cameraSerial | Mac | Timestamp | Signal | Type

SWA05 = [Count DISTINCT (Last 60 Days Matching Mac)/Count DISTINCT (Mac of selected date)]*100% 

Area , Site

Output Type

Timestamp, Time_Range

Data Format

Percentage (decimal, decimal(2))

Raw Log
SWA04 - Returning Customer Rate in the Last 14 Days

SWA06 = 100% - SWA04

Output Type

Timestamp, Time_Range

Data Format

Percentage (decimal, decimal(2))

Raw Log
SWA05 - Returning Customer Rate in the Last 60 Days

SWA07 = 100% - SWA05

Output Type

Timestamp, Time_Range

Data Format

Percentage (decimal, decimal(2))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Raw Log
RL09 - AreaID | MeetingID | SessionID | BookingID | MeetingStartDateTime | MeetingEndDateTime | MeetingDuration | MeetingStatus | MeetingAvgOccupancy |

PMM01 - No. of Meetings

SMM05 = (Count(MeetingID) where MeetingStatus in [S]) / PMM01 * 100%

Remark:
MeetingStatus [S]

• BookedNoShow
• ShowedNoBook
• CompletedEarly
• CompletedOnTime
• CompletedLate

Output Type
-

Data Format
Percentage (decimal, decimal(2))

Raw Log
RL09 - AreaID | MeetingID | SessionID | BookingID | MeetingStartDateTime | MeetingEndDateTime | MeetingDuration | MeetingStatus | MeetingAvgOccupancy |

PMM04 - No. of Booked and Showed Meetings

SMM06 = (Count(MeetingID) where BookingID != NULL and SessionID ! NULL and MeetingStatus in [S]) / PMM04 * 100%

Remark:
MeetingStatus [S] 

• CompletedEarly
• CompletedOnTime
• CompletedLate

Output Type
-

Data Format
Percentage (decimal, decimal(2))

Raw Log
RL09 - AreaID | MeetingID | SessionID | BookingID | MeetingStartDateTime | MeetingEndDateTime | MeetingDuration | MeetingStatus | MeetingAvgOccupancy |

PMM03 - No. of Occupied Meetings

Output Type
-

Data Format
Count (decimal, decimal(2))

SMM08 = [No. of meetings where SessionID != NULL and (MeetingAvgOccupancy ≥ X and MeetingAvgOccupancy ≤ Y)] / (PMM01) x 100%

Remark:
X and Y are target occupancy set

Output Type
-

Data Format
Percentage (decimal, decimal(2))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
-

Data Format
Count (integer, int(32))

Output Type
Live, Timestamp, Time_Range

Data Format
Count(integer, int(32))