> I need the ability to query by date. I don't quite understand what you mean 
> by your last comment with regards date. Please could you elaborate?

If your view is like this:
["UK", 2011, 10, 6, 20, 30]             null
["UK", 2011, 9, 31, 7, 59]              null
["UK", 2012, 10, 6, 21, 31]             null
["USA", 2011, 9, 1, 12, 00]             null
["USA", 2012, 10, 5, 8, 10]             null
["USA", 2012, 10, 6, 20, 03]    null
["USA", 2012, 10, 6, 21, 31]    null
["USA", 2012, 10, 6, 21, 40]    null

You can query it with group_level=5 and get:
["UK", 2011, 10, 6, 20]         1
["UK", 2011, 9, 31, 7]          1
["UK", 2012, 10, 6, 21]         1
["USA", 2011, 9, 1, 12]         1
["USA", 2012, 10, 5, 8]         1
["USA", 2012, 10, 6, 20]        1
["USA", 2012, 10, 6, 21]        2

with group_level=4:
["UK", 2011, 10, 6]     1
["UK", 2011, 9, 31]     1
["UK", 2012, 10, 6]     1
["USA", 2011, 9, 1]     1
["USA", 2012, 10, 5]    1
["USA", 2012, 10, 6]    3

with group_level=3:
["UK", 2011, 10]        1
["UK", 2011, 9] 1
["UK", 2012, 10]        1
["USA", 2011, 9]        1
["USA", 2012, 10]       4

with group_level=2:
["UK", 2011]            2
["UK", 2012]            1
["USA", 2011]   1
["USA", 2012]   4

with group_level=1:
["UK"]  3
["USA"] 5

So to get all of these stats, you just need to split the date into year, month, 
hour, minute when you emit the key.


Regards,

Aurélien

Reply via email to