Daily Revenue

The daily trend of the revenue.

Description

This example shows how to apply daily aggregation and filtering. The queries below are applying the aggregate functions, to the last 7 days worth of data.

Sample Input

pay
time user_id price count
1416435585 2 100 3
1416435586 3 500 1
1416435587 5 100 10
1416435588 1 100 8
... ... ... ...

Query


to view this query

Sample Output

day revenue
2014-10-01 10000
2014-10-02 1030
2014-10-03 3033
2014-10-04 2345
2014-10-05 9390
2014-10-06 1103
2014-10-07 8329