github.com/rohankumardubey/aresdb@v0.0.2-0.20190517170215-e54e3ca06b9c/examples/1k_trips/queries/total_fare.aql (about) 1 { 2 "queries": [ 3 { 4 "table": "trips", 5 "measures": [ 6 { 7 "alias": "value", 8 "sqlExpression": "sum(fare)", 9 "rowFilters": [ 10 "status='completed'" 11 ] 12 } 13 ], 14 "timeFilter": { 15 "column": "request_at", 16 "from": "24 hours ago", 17 "to": "this quarter-hour" 18 }, 19 "dimensions": [ 20 { 21 "alias": "ts", 22 "sqlExpression": "request_at", 23 "timeBucketizer": "hour" 24 } 25 ], 26 "joins": [] 27 } 28 ] 29 }