Summative issue with doubleheaders

[John Currey]

Hi,

This shows Dodger games in 2022 where they won 3 straight games using the p: method to locate the games. 

• date,team,o:team,margin>0@p:W and p2:W and p3:W and team=Dodgers and season=2022

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cmargin%3E0%40p%3AW+and+p2%3AW+and+p3%3AW+and+team%3DDodgers+and+season%3D2022&submit=++S+D+Q+L+%21++

This shows Dodger games in 2022 where they won 3 straight games using the summative method to locate the games. 

• date,team,o:team,margin>0@tS(W,N=3)=3 and season=2022 and team=Dodgers

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cmargin%3E0%40tS%28W%2CN%3D3%29%3D3+and+season%3D2022+and+team%3DDodgers&submit=++S+D+Q+L+%21++

In theory, the results of the 2 queries should be the same. The difference is the summative method missed the 5/17 game.

This shows all Dodger games for 2022. On 5/17, the Dodgers swept a doubleheader and the win made the Dodgers 3 games into a 7-game win streak. It seems the summative missed game 2. 

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cmargin%3E0%40team%3DDodgers+and+season%3D2022&submit=++S+D+Q+L+%21++

Thanks. 

[Joe Meyer]

John and SDQL API Friends,

this is now working correctly.

The only time 

tS(W,N=3)=3

would yield a different result than

p:W and p2:W and p3:W

is if runs is None for one of the 3 previous games as Aggregators skip over None.

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/01bb248a-ef09-4947-9ffa-0e8bc8b1311en%40googlegroups.com.