Multiple Sets of Data?

TripleC106

unread,

Sep 26, 2021, 9:17:30 AM9/26/21

to SportsDataBase

When I run:

date,day,week,season,site,team,o:team,points,o:points,line,o:line,total,margin,ats margin,ou margin,Record((points-o:points,0,100)) as 'SU Record',Record((points-o:points+line,1.91,100)) as 'ATS Record',Record((points+o:points-total,1.91,100)) as 'OU Record'@Wk<4 and F and division and total>=50

It is giving me multiple sets of data with different records. Am I doing something wrong? This happens often.

mrpi...@gmail.com

unread,

Oct 6, 2021, 7:24:27 AM10/6/21

to SportsDataBase

It splits them into divisions, if you remove division you get one list link

TripleC106

unread,

Oct 6, 2021, 2:39:12 PM10/6/21

to SportsDataBase

Right but I would like to see what the overall records are for division games. That was how you did it before. How do you do it now? I don’t want it split out.

mrpi...@gmail.com

unread,

Oct 7, 2021, 6:15:57 AM10/7/21

to SportsDataBase

division=o:division

dean.on...@gmail.com

unread,

Oct 30, 2021, 11:05:56 AM10/30/21

to SportsDataBase

Just simply add a pipe '|' to the end of the query then the Records will split per division.

NOTE: right now it shows there is a 'CENTRAL' division for both AFC and NFC though! :( so you'll get 10 divisions instead of 8!

date,day,week,season,site,team,o:team,points,o:points,line,o:line,total,margin,ats margin,ou margin,Record((points-o:points,0,100)) as 'SU Record',Record((points-o:points+line,1.91,100)) as 'ATS Record',Record((points+o:points-total,1.91,100)) as 'OU Record'@Wk<4 and F and division and total>=50|

Reply all

Reply to author

Forward