| artistGROUP BY | song_titleGROUP BY | weeks_at_ number_oneCOUNT FILTER |
weeks_in_ top_tenCOUNT FILTER |
weeks_in_ top_fortyCOUNT FILTER |
pct_time_ in_top_tenNULLIF ÷ |
median_ positionPERCENTILE_CONT |
peak_ positionFIRST_VALUE |
dominance_ rankDENSE_RANK |
market_ presenceNTILE(4) |
market_ reachINTERSECT/EXCEPT |
all_charting_songsSTRING_AGG | genreCOALESCE | best_weekLATERAL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ABBA | Waterloo | 6 | 12 | 14 | 85.7 | 2.0 | 1 | 1 | Dominant | UK + US crossover | Honey Honey, Ring Ring, Waterloo | Glam Pop | 1974-04-06 |
| Stevie Wonder | You Haven't Done Nothin' | 5 | 11 | 15 | 73.3 | 3.0 | 1 | 1 | Dominant | UK + US crossover | Boogie On Reggae Woman, Don't You Worry 'Bout a Thing, You Haven't Done Nothin' | Soul | 1974-09-21 |
| Elton John | Crocodile Rock | 4 | 10 | 13 | 76.9 | 4.5 | 1 | 2 | Dominant | UK + US crossover | Bennie and the Jets, Crocodile Rock, Don't Let the Sun Go Down on Me | Pop Rock | 1974-01-12 |
| Mud | Tiger Feet | 4 | 9 | 11 | 81.8 | 3.0 | 1 | 2 | Dominant | UK only | The Cat Crept In, Tiger Feet | Glam Rock | 1974-02-02 |
| David Bowie | Rebel Rebel | 3 | 9 | 12 | 75.0 | 5.0 | 1 | 3 | Dominant | UK + US crossover | Diamond Dogs, Knock on Wood, Rebel Rebel | Glam Rock | 1974-03-09 |
| Suzi Quatro | Devil Gate Drive | 2 | 8 | 10 | 80.0 | 4.0 | 1 | 4 | Strong | UK only | Devil Gate Drive, Too Big | Glam Rock | 1974-02-23 |
| The Rubettes | Sugar Baby Love | 2 | 7 | 9 | 77.8 | 5.5 | 1 | 4 | Strong | UK only | Sugar Baby Love | Bubblegum Pop | 1974-05-18 |
| Barry White | Can't Get Enough of Your Love | 2 | 8 | 11 | 72.7 | 5.0 | 1 | 4 | Strong | UK + US crossover | Can't Get Enough of Your Love, You're the First the Last My Everything | Soul | 1974-08-03 |
| Slade | Everyday | 1 | 7 | 10 | 70.0 | 6.0 | 2 | 5 | Strong | UK only | Bangin' Man, Everyday, How Does It Feel | Glam Rock | 1974-06-15 |
| Marvin Gaye | Let's Get It On | 1 | 6 | 9 | 66.7 | 7.0 | 1 | 5 | Strong | UK + US crossover | Let's Get It On, Wherever I Lay My Hat | Soul | 1974-01-19 |
| John Denver | Sunshine on My Shoulders | 1 | 5 | 8 | 62.5 | 8.0 | 1 | 5 | Moderate | US only | Annie's Song, Sunshine on My Shoulders | Country Pop | 1974-03-02 |
| T. Rex | Teenage Dream | 0 | 5 | 9 | 55.6 | 9.5 | 3 | 6 | Moderate | UK only | Teenage Dream, Truck On (Tyke), Zip Gun Boogie | Glam Rock | 1974-05-04 |
| Olivia Newton-John | I Honestly Love You | 0 | 4 | 8 | 50.0 | 10.5 | 4 | 7 | Moderate | UK + US crossover | I Honestly Love You, Long Live Love | Pop | 1974-09-28 |
| Sweet | The Six Teens | 0 | 4 | 7 | 57.1 | 11.0 | 5 | 7 | Moderate | UK only | The Six Teens, Turn It Down | Glam Rock | 1974-07-27 |
| Paul McCartney & Wings | Jet | 0 | 3 | 7 | 42.9 | 13.0 | 7 | 8 | Moderate | UK + US crossover | Band on the Run, Helen Wheels, Jet | Pop Rock | 1974-02-09 |
| The Jackson 5 | Dancing Machine | 0 | 3 | 6 | 50.0 | 14.0 | 8 | 8 | Struggling | UK + US crossover | Dancing Machine, The Boogie Man | Soul | 1974-06-01 |
| Gary Glitter | Always Yours | 0 | 2 | 5 | 40.0 | 16.5 | 9 | 9 | Struggling | UK only | Always Yours, Remember Me This Way | Glam Rock | 1974-06-22 |
| Ringo Starr | You're Sixteen | 0 | 2 | 4 | 50.0 | 18.0 | 12 | 9 | Struggling | UK + US crossover | Oh My My, You're Sixteen | Unclassified | 1974-01-26 |