Why Late Data can happen?
Late data can happen when some devices are offline before the data is retrieved via the API. This prevents the data from being sent to our database in real-time.
Below is an example payload and the corresponding output:
Payload
{
"query": {
"measures": [
"ffc_site_summary.A01",
"ffc_site_summary.A02"
],
"dimensions": [
"ffc_site_summary.AggregationStatus",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime"
],
"filters": [
{
"member": "ffc_site_summary.BranchId",
"operator": "equals",
"values": [
"123"
]
}
],
"timeDimensions": [
{
"dimension": "ffc_site_summary.Time",
"dateRange": [
"2024-08-17T00:00:00.000",
"2024-08-22T23:59:59.999"
],
"granularity": "day"
}
],
"order": [
[
"ffc_site_summary.Time",
"asc"
]
],
"offset": 0,
"limit": 100
}
}
Output Data
"data": [
{
"ffc_site_summary.AggregationStatus": "Complete",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-18T00:13:59.000"
"ffc_site_summary.Time.day": "2024-08-17T00:00:00.000",
"ffc_site_summary.Time": "2024-08-17T00:00:00.000",
"ffc_site_summary.A01": 234,
"ffc_site_summary.A02": 214
},
{
"ffc_site_summary.AggregationStatus": "Missing Data",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-18T22:32:02.000"
"ffc_site_summary.Time.day": "2024-08-18T00:00:00.000",
"ffc_site_summary.Time": "2024-08-18T00:00:00.000",
"ffc_site_summary.A01": 112,
"ffc_site_summary.A02": 84
},
{
"ffc_site_summary.AggregationStatus": "Missing Data",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-19T21:21:13.000"
"ffc_site_summary.Time.day": "2024-08-19T00:00:00.000",
"ffc_site_summary.Time": "2024-08-19T00:00:00.000",
"ffc_site_summary.A01": 23,
"ffc_site_summary.A02": 52
},
{
"ffc_site_summary.AggregationStatus": "Missing Data",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-20T22:13:25.000"
"ffc_site_summary.Time.day": "2024-08-20T00:00:00.000",
"ffc_site_summary.Time": "2024-08-20T00:00:00.000",
"ffc_site_summary.A01": 142,
"ffc_site_summary.A02": 121
},
{
"ffc_site_summary.AggregationStatus": "Late Data",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-21T23:58:43.000"
"ffc_site_summary.Time.day": "2024-08-21T00:00:00.000",
"ffc_site_summary.Time": "2024-08-21T00:00:00.000",
"ffc_site_summary.A01": 187,
"ffc_site_summary.A02": 193
},
{
"ffc_site_summary.AggregationStatus": "Precheck",
"ffc_site_summary.AggregationStatusLastUpdateUTCDateTime": "2024-08-22T14:23:10.000"
"ffc_site_summary.Time.day": "2024-08-22T00:00:00.000",
"ffc_site_summary.Time": "2024-08-22T00:00:00.000",
"ffc_site_summary.A01": 12,
"ffc_site_summary.A02": 23
}
],