google bigquery - Discrepancy when using group by clause -


i see discrepancy in count because of group clause, please advise how go this.

total records in table 4638 when count(you_id), when run script i'm getting 4544 records.

select     thumbnails,     cr1,     monetize,     c_id,     you_id,     vendor,     ratio * 100 percent (     select thumbnails, c_id,you_id, vendor,cr1,monetize,timestamp,            count(*) total, ratio_to_report(total) over() ratio     testing     group 1,2,3,4,5,6,7 ); 


Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -