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
Post a Comment