FootySphere

Preliminary Finals

Preliminary Final Fri 18 Sep FINAL
Sydney SYD
71–83
Fremantle FRE
S.C.G.
Preliminary Final Sat 19 Sep FINAL
Hawthorn HAW
122–131
Brisbane Lions BRI
M.C.G.
FootySphere FootySphere
  • HomeHome
  • AFL Ladder
  • Player ComparisonsPlayer Comparisons
  • GamesGames
  • TrendingTrending
  • Data & GlossaryData & Glossary
  • ExamplesExamples
  • Guides
  • AboutAbout
  • Sign In
  • Register
Guides / Narrowing a search with filters
Recommended guide Using FootySphere

Narrowing a search with filters

A phrase-by-phrase guide to seasons, opponents, venues, weather, player presence and the conditions behind an answer.

By FootySphere · Published 22 September 2026 · Updated 22 September 2026

Start with this question

Which ten players kicked the most total goals at the MCG in 2024?
View this result →

What to look for

The Venue column confirms the MCG filter. Kysaiah Pickett and Bayley Fritsch each have 25 goals in this selection, despite different game counts. These are MCG totals, not their full-season totals.

A saved excerpt of this result appears below, with its scope and a link to the full answer.

Build a question one phrase at a time

Start with who or what, then the statistic and calculation, then the period and conditions. This is a useful writing order, not a rigid command format. Put each phrase next to the thing it describes so it is clear whether you are selecting players, selecting games or changing the calculation.

Begin with “Which ten players kicked the most total goals in 2024?” Add at the MCG to get “Which ten players kicked the most total goals at the MCG in 2024?” The statistic, season and calculation stay the same; the venue now narrows the included games. The saved MCG result below shows what that changes.

Next, you could ask “Which ten players kicked the most total goals at the MCG in the 2024 regular season?” That adds a competition-stage condition. Changing total goals to goals per game would be a different step: it changes the calculation instead of adding another match restriction.

There is no benefit in adding every possible filter at once. Establish a result you understand, add a phrase, then check the scope and game count. The reference below covers the main families of conditions and answer controls. Some detailed combinations depend on records that do not exist for every season.

Set the period first

Use a year for a season, or name the round if you want a smaller slice. Say “finals” or “regular season” when that distinction matters. A regular-season filter refers to the competition stage; it is different from asking for matches played at a team’s home venue.

When revisiting an old question, replace “last season” with the exact year. Relative dates move with time. A specific season keeps your intended period clear.

Add opponent, venue or result

An opponent filter selects who the player or team faced. A venue filter selects where the match was played. They are separate conditions: a game against Collingwood was not necessarily played at the MCG.

You can also ask about wins or losses. Check whose result is being used, especially in a player question. For home and away questions, check the listed matches rather than assuming a shared venue always counts as a home game.

Example result

Which ten players kicked the most total goals at the MCG in 2024?

Kysaiah Pickett and Bayley Fritsch are tied for the most total goals, with 25 goals each.

Excerpt from Which ten players kicked the most total goals at the MCG in 2024?
#GoalsPlayerTeamYearsGamesVenue
125Kysaiah PickettMEL202413M.C.G.
225Bayley FritschMEL202414M.C.G.
320Jacob van RooyenMEL202414M.C.G.

3 rows shown from the saved result. Captured 22 September 2026.

What games were included?
  • Recorded regular-season and finals games in 2024 at the MCG.
  • Results are sorted by total Goals, highest first.
  • Up to 10 results are shown.
  • Goals: recorded since 1912.

The Venue column confirms the MCG filter. Kysaiah Pickett and Bayley Fritsch each have 25 goals in this selection, despite different game counts. These are MCG totals, not their full-season totals.

Open the full result →

Be precise about a cutoff

“At least 6” includes 6. “More than 6” starts at 7 for a whole-number statistic. “Exactly 6” includes only 6. These phrases can select different matches even when the rest of the question is identical.

Two conditions joined by “and” should both hold in the same selected match. “35 disposals and 10 tackles in a game” is different from asking for games with either achievement. State “at least” if you intend a lower limit rather than an exact tally.

Check a filtered answer against a broader search

Start with “Marcus Bontempelli average clearances in 2024”, then add “in games where he had at least 6 inside 50s”. Keep both questions handy. The second average describes a subset of his season, so a change in the answer is expected if the selected games have different clearance tallies.

Look through the included games for the filtered question. Each qualifying match should meet the inside-50 condition, while the number being averaged should still be clearances. This separates the statistic used to choose the games from the statistic used to answer the question.

If the selected matches do not match your intention, rewrite the condition explicitly. Avoid shortening the question to “Bontempelli clearances 6 inside 50s”, which leaves the relationship between those two measures unclear.

Watch the number of games left

Each extra condition can shrink the sample. A season average may become an average from only two matches after an opponent and venue are added. Read the game count before treating the result as a pattern.

If nothing is returned, remove the last condition and try again. Keep the useful parts of the question and add the remaining filters separately. This helps you find an overly narrow condition or wording the search did not interpret as intended.

Use the game-log controls without writing another search

On a player profile, open Game Log. The filters let you select season, team, venue, result, opponent and round type. The team selection is useful for a player who changed clubs: it lets you separate appearances for one club from the rest of their career.

The statistical filter lets you choose a measure, a comparison and a value. For example, select disposals, at least, and 30 to look for appearances reaching that mark. The available measures include familiar counts such as goals and tackles, as well as more detailed measures such as metres gained and intercepts where recorded.

This is handy when you want to try several cutoffs on the same player. Keep an eye on the remaining rows as you change the value. Clear filters when you move to a different question; otherwise a venue or result selection from the previous search can quietly narrow the new one.

Filter a team’s opponents and the players it faces

A team’s attacking output and what it allows the opposition are separate questions. “Which team gives up the most points at Subiaco before 2009?” asks about points conceded at a venue, not points scored by that team. Check that the result describes the defending side and the requested period.

FootySphere also has questions involving playing positions. “Most goals allowed to half-forwards in 2024?” concerns output allowed to a group of opposition players. The position selection matters: it does not mean every goal conceded by the team. Read the position and recording notes rather than assuming a player had the same role in every appearance.

Seasons, rounds and recent appearances

Put the time period after the statistic or at the end of the question. A season, a round and a number of appearances are different ways to select time. Use one clear starting point, then add a narrower period if needed.

Phrase to addWhere it fitsWhat it changes
in 2024After the statisticSelects the named season. It does not by itself say regular season only; check the finals scope.
before 2024After the statisticSelects earlier seasons and excludes 2024. Use this when the named year is a boundary, not a season you want included.
after 2022After the statisticSelects seasons later than 2022. It is different from including the 2022 season.
between 2020 and 2024After the statisticSets a bounded season range. Check the returned start and end years before comparing it with another period.
in Round 5 of 2024At the endNarrows the question to a round within a season. Giving both avoids matching the same round number across many years.
in finalsAfter the year or statisticKeeps finals appearances. A team that missed finals will have no games in that season’s selection.
in the regular seasonAfter the year or statisticExcludes finals. This describes the competition stage, not whether the team was playing at home.
in his last 8 gamesAfter a named player and statisticUses recent player appearances rather than eight fixture rounds. Missed matches can make the selected dates stretch further back.
in their first AFL gameAfter the statisticLimits the question to debut appearances. It does not mean the first match of each season.

Clubs, opponents and where the game was played

Keep the player’s team separate from the opposition. Then decide whether location means one ground, a state or travel outside the team’s home state. These conditions can be combined, but they are not interchangeable.

Phrase to addWhere it fitsWhat it changes
for SydneyAfter the player or statisticSelects appearances for Sydney. For a player who changed clubs, this is only part of the career.
against CollingwoodAfter the statisticSelects matches against that opponent. It does not imply a venue or a home/away designation.
at the MCGAfter the statistic or opponentKeeps matches at one ground. A ground shared by clubs can host both home and away appearances.
in home gamesAfter the team and statisticUses the match’s home-team designation. It is not simply a list of matches at a familiar ground.
in away gamesAfter the team and statisticUses the away-team designation. A team can play away without travelling interstate.
at venues in VictoriaAfter the statisticFilters by the ground’s state. This is a location condition, regardless of where either club is based.
for teams based in VictoriaBeside the team selectionFilters the team’s state rather than the venue’s state. Check the selected teams when working across historical periods.
in interstate gamesAfter a named team and statisticCompares the venue’s state with the team’s home state. A match can be interstate for one side and not the other.

Match results and score conditions

A result filter chooses matches by their outcome. A score-state condition concerns a point during the match. Make the team’s point of view clear, especially if both teams appear in the question.

Phrase to addWhere it fitsWhat it changes
in winsAfter the player or team statisticKeeps matches won by the selected side. For a player, read this as the result of their team’s match.
in lossesAfter the player or team statisticKeeps defeats. An average from losses can use a very different number of games from the same player’s average in wins.
in drawsAfter the player or team statisticKeeps drawn matches. This is often a small selection, so inspect the game count.
in games decided by 6 points or lessAfter a team-record requestRestricts the final margin. It does not mean the teams stayed within six points throughout the match.
while trailingBeside a scoring-period requestAsks about the selected team’s score state during play. This needs scoring-sequence data; it is not the same as games eventually lost.
while leadingBeside a scoring-period requestAsks about the selected side being ahead during play. Check the event or period used by the result.
while scores were levelBeside a scoring-period requestUses a tied score state during the match, rather than requiring a draw at full time.

Statistical cutoffs and qualifying games

Put a condition after “in games where” when it is meant to choose matches. Put a minimum appearance requirement beside an average leaderboard when it is meant to choose players. This distinction matters more than the order of the words.

Phrase to addWhere it fitsWhat it changes
at least 30 disposalsAfter “in games where he had”Includes 30 and every larger recorded tally. This is a lower limit, not an exact match.
more than 30 disposalsAfter “in games where he had”Excludes 30. For a whole-number count, the first qualifying value is 31.
exactly 30 disposalsAfter “in games where he had”Keeps only a tally of 30. Neither 29 nor 31 qualifies.
at most 2 goalsAfter “in games where he kicked”Includes 2 and lower recorded tallies, including zero where it was recorded.
fewer than 2 goalsAfter “in games where he kicked”Excludes 2. For whole-number goals, recorded values of zero or one qualify.
at least 35 disposals and at least 10 tacklesAfter “players who had”Requires both thresholds in the same game when the question specifies a single-match achievement.
with at least 10 games playedAfter a per-game leaderboardSets an appearance requirement for qualifying players. Check that the counted games use the same season and match scope as the average.
in games where he had at least 6 inside 50sAfter an average-clearances requestUses inside 50s to select matches, then calculates clearances from those matches. The selection statistic and answer statistic are different.

Quarters, roles and who took part

These phrases can change which part of a performance is used or which participants qualify. A player being selected for a match does not establish that they were on the ground at the same time as another player.

Phrase to addWhere it fitsWhat it changes
in third quartersAfter a scoring statisticUses the third-quarter portion of the available scoring records. It does not include the player’s other quarters.
in first halvesAfter a supported period statisticRequests the opening half rather than a whole-game total. Check coverage for the selected statistic and seasons.
in second halvesAfter a supported period statisticRequests the later half. Keep the same period when comparing it with another player or team.
with Patrick Cripps in the sideAfter a Carlton team-record requestSelects matches with that player’s recorded participation. This describes a set of games; it does not prove the player caused the result.
without Patrick CrippsAfter a Carlton team-record requestSelects matches without that player’s participation. Check team and year scope so another part of the club’s history is not included accidentally.
against a named opponent playerAfter the target player’s name or statisticRestricts the shared opposing appearances. It does not establish that the two players directly marked each other.
by full forwardsBeside the player groupUses the recorded playing-position selection. A player’s role may differ between appearances.
wearing number 9Beside an appearance or player requestFilters the recorded jumper number. Numbers can change between clubs or seasons, so this is not a permanent player identifier.

Weekdays, start times and weather

These filters depend on match metadata. If a game has no usable weather or start-time record, do not assume it belongs in the opposite category. Read coverage notes when comparing the selected group with a full-season total.

Phrase to addWhere it fitsWhat it changes
on FridaysAfter the statistic or seasonSelects the weekday of the match using available local match timing. The same approach applies to other named weekdays.
in day gamesAfter the statisticSelects the daytime start-time category. It describes when the match starts, not whether every minute was played in daylight.
in twilight gamesAfter the statisticSelects the separate twilight start-time category. It is not a synonym for all afternoon or evening matches.
in night gamesAfter the statisticSelects the night start-time category using the available local timing information.
in rainy gamesAfter the statisticUses the recorded rainy weather category. It does not measure how much rain fell or whether every quarter was wet.
in sunny gamesAfter the statisticSelects the sunny category. Clear and cloudy are separate supported categories; avoid treating all non-rainy records as sunny.
in windy gamesAfter the statisticUses the recorded windy flag. Wind information is separate from the sunny, clear, cloudy or rainy label.

Phrases that change the answer rather than filter games

These are useful controls too, but they do a different job. Adding “per game” changes the calculation. Adding “top 10” changes how much of the ranking you ask to see. Neither is another venue or season condition.

Phrase to addWhere it fitsWhat it changes
totalBefore the statisticAdds the selected values. Use it when the output across all selected appearances is the point of the question.
average … per gameAround the statisticRequests a per-appearance measure. Inspect the game count and missing-data notes alongside it.
in a single gameAfter “most” and the statisticCompares individual performances instead of season or career aggregates.
top 10Before the player or team groupRequests a limited leaderboard. Ten displayed results does not mean only ten players qualified.
show … game logAround a player and periodRequests individual match rows so you can inspect the performances rather than only their total.
first gameBefore an achievement conditionFinds the earliest qualifying appearance. “Most recent game” asks for the other end of the timeline.
longest streakBefore a performance conditionLooks for consecutive qualifying performances. This differs from counting qualifying games scattered across a career.

Check what each phrase actually changed

Compare the original answer with the narrowed answer. Has the game count fallen? Does the venue column show the ground you asked for? Is the answer still a total, or did you change it to an average? Read the included-game explanation before interpreting a new leader as a change in player quality.

With a player describes participation, against a player describes opposing appearances, and for a club describes the team whose appearances are selected. None of those phrases means the same thing as a direct matchup or minutes spent together on the ground.

If several filters leave no results, remove the last phrase first. A finals-only search at one venue against one opponent can be empty even though every phrase is individually meaningful. Missing weather, position or scoring-sequence records are another reason to inspect the coverage rather than read an empty table as zero.

Try a related question

  • Hawks record at MCG ↗
  • Games where Isaac Heeney had at least 2 marks in 2025 ↗
  • Who had at least 35 disposals and at least 10 tackles in the same game in 2025? ↗

Check statistic definitions and recording periods in Data & Glossary. Found something wrong? Tell us what you found.

In this guide

Start with this question Build a question one phrase at a timeSet the period firstAdd opponent, venue or resultBe precise about a cutoffCheck a filtered answer against a broader searchWatch the number of games leftUse the game-log controls without writing another searchFilter a team’s opponents and the players it facesSeasons, rounds and recent appearancesClubs, opponents and where the game was playedMatch results and score conditionsStatistical cutoffs and qualifying gamesQuarters, roles and who took partWeekdays, start times and weatherPhrases that change the answer rather than filter gamesCheck what each phrase actually changed Try a related question

Read next

Totals, averages and single-game highs →When a question returns an unexpected result →

Looking for a question to try?

Browse Examples →
FootySphere v1.6.3 Active visitors: 630
Email us @Footy_Sphere
Privacy · Terms · Contact ·
FootySphere is an independent, unofficial project and is not affiliated with, endorsed by, or sponsored by the AFL or its clubs. Data is compiled from third-party sources and updated after official fixture releases.
Essential cookies keep FootySphere working. With your permission, we also use analytics and advertising cookies. Learn more in our Privacy Policy.

Multiple profiles found

Which role did you mean?

Share

Send this page using the link below.

Create an account to use bookmarks

Save players, teams, matches, and searches so you can revisit them anytime.