Aggregation Query
Examples
Aggregation Query
Aggregation Query DSL
Horizon AI Python SDK
Managing Continuous Query
Continuous Query Results
Query API
Aggregation Query
Examples
A couple of examples to get you started with Continuous Query:
Daily Sleep Analysis
import vitalx.aggregation as va
va.select(
va.group_key("*"),
va.Sleep.col("efficiency").mean(),
va.Sleep.score().mean(),
va.Sleep.chronotype().newest()
).group_by(
va.date_trunc(va.Sleep.index(), 1, "day")
).split_by_source(enabled=False)
.finalize()
Weekly Insights Into Users Activity
import vitalx.aggregation as va
va.select(
va.group_key("*"),
va.Activity.col("heart_rate_resting").mean(),
va.Activity.col("calories_total").max(),
va.Activity.col("steps").min(),
va.Activity.col("duration_active_seconds").mean()
).group_by(
va.date_trunc(va.Activity.index(), 1, "week")
).split_by_source(enabled=False)
.finalize()