Home › Forums › KX Academy › Advanced Capstone 1.3 clarification › Re: Advanced Capstone 1.3 clarification
-
#spoiler
distinctSensors: distinct select sensorId from sensor
crosspdt:(select from event) cross distinctSensors
windows:(crosspdt[`time];crosspdt[`endtime])
f:{avg each x}
wj[windows;`sensorId`time;select from crosspdt;(select from sensor;(f;`sensorValue))]Pls suggest