time - Event within timeframe (without date) in Keen.io -


is there way query events have occurred between 12am - 9am on date?

the way accomplish using keen.timestamp run query each individual day timeframe of 12:00 9:00 (or filter same timespan) particular day. filtering keen.timestamp requires both date , time prevents using time separately.

that being said, adjust data model include property called hour_of_day, , filter on it's between 0 , 9 (assuming 24 hour clock). way specify timeframe in query.

sample event:

{   "action":"signed_up".   "ip_address":"11.22.33.44",   "hour_of_day":6 } 

i don't recommend unbounded queries though (queries without timeframe) performance suffer. data indexed on keen.timestamp makes queries specify timeframes faster don't.


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -