Summatives including site

[Austin Wang]

Hello,

I've tried to use summatives to come up with home and away splits for certain statistical categories. It does not appear to be working as expected.

I've tried to slice and dice this a few different ways, but as you can see in the link below, the results for when I defined H and A as a condition return the same output.

https://s3.sportsdatabase.com/NBA/query.html?sdql=R%28team%29%2CtA%28points%29%2CAverage%28points%40team+and+season+and+H%29%2CAverage%28points%40team+and+season+and+A%29%40season%3D2021+and+team%7C&submit=++S+D+Q+L+%21++

Thanks,
AW

[Joe Meyer]

AW,

thanks for the question and link.

Conditions in Fields are silently ignored.

(Fields are the terms to the left of the @ sign.)

Consider this form instead

R(_key[-3][-1]),R(_key[-1][-1]),S(1),A(points)@season=2021 and team and H,A,1|

https://s3.sportsdatabase.com/NBA/query.html?sdql=R%28_key%5B-3%5D%5B-1%5D%29%2CR%28_key%5B-1%5D%5B-1%5D%29%2CS%281%29%2CA%28points%29%40season%3D2021+and+team+and+H%2CA%2C1%7C&submit=++S+D+Q+L+%21++

best regards,

Joe Meyer

Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/32ba92df-3251-44a5-a147-0677bc147960n%40googlegroups.com.