[ab]

can you please help with this question. Pasting the code I have written. Also how to test it locally?

#spoiler

.z.pg:{[msg] user: msg[`user];query: msg[`query]; if[any .perm.users[`user = user; api = “all”]; : value query];firstElem: .perm.parseQuery query;if[any .perm.users[`user = user; api = firstElem]; : value query];”notAuthorized”;};

[ab]

hi yes, I’m facing the exact same problem. Please find the attached ss.

 

 

[ab]

hey yes already worked. thanks for the help.

[ab]

hi, can you please help me with your solution. I’m stuck on this problem since 2 days.

[ab]

#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