Reproducible query — Product (shared drive)
SUM REVISIONS SIZE_BYTES BY MODIFIED_BY
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
| alice@acme.com | 0 |
1 groups · 0 rows total
7 of 8 matching rows have no SIZE_BYTES value and contributed nothing to this total. The sum covers 1 rows, not 8 — treat it as a partial total unless you know the missing rows should be zero.
Coverage1 of 8 rows contributed a value.
epoch 1source gdrive:revisionsas of 2026-09-14T21:44:11Ztransforms type-coercioncache hit
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "SUM",
"subject": "REVISIONS",
"data": {
"groups": [
{
"group": "alice@acme.com",
"sum": 284500
}
],
"field": "SIZE_BYTES",
"rows_considered": 8,
"rows_contributing": 1,
"rows_missing_value": 7
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:revisions",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion"
]
},
"related": [
"COUNT REVISIONS BY MODIFIED_BY"
],
"hints": [
"7 of 8 matching rows have no SIZE_BYTES value and contributed nothing to this total. The sum covers 1 rows, not 8 \u2014 treat it as a partial total unless you know the missing rows should be zero."
],
"completeness": {
"rows_considered": 8,
"rows_contributing": 1,
"rows_missing_value": 7,
"complete": false
},
"cache": "hit"
}
}