top of page
horizontal lines
Gigasheet Primary logo
  • Laura Waterbury

Multi-Value Filters vs. Fantasy Football Data

Multi-Value Filtering vs. Fantasy Football Data

Gigasheet’s ability to filter data has long been a fan favorite, and for a good reason! It is an efficient way for users to sort through massive amounts of data by stacking several AND and OR functions, similar to SQL queries.

In the past, filters were specified value by value, often times leading to an extensive list of functions. Well, no more! Long gone are the days of seemingly endless filter conditions. Introducing, ✨Multi-Value Filters✨.

Rather than flooding the screen with redundant filter conditions, we’ve improved the process by adding multi-value capabilities to select data types. Take multi-value filters for a spin with some sample NFL Player Data available in our Data Community.

Let’s put together your Fantasy Football dream team in under 5 minutes, including set-up, by using multi-value filters to streamline the process.

The Playbook

The set-up is simple:

  1. If you haven’t already, sign up for Gigasheet (I mean, seriously! What are you waiting for?).

  2. Upload this CSV file or, even easier, save a copy of the Data Community data to your Gigasheet account, containing the stats of every NFL player, past and present.

  3. Admire how simple steps one and two were (not required but strongly encouraged).

Start by grouping the players by their current status.

Players Grouped by Status

Your chances of taking home this year’s Fantasy Football trophy are slim to none if you sign a retired, injured, or suspended athlete, so start by filtering out those players.

Filtering Status

Now that we have our list of active players, we can start adding more in-depth filtering.

Let’s say you grew up in the South and want to include some players after your own heart. Rather than adding a separate line for Florida, Georgia, Tennessee, and so on, include them in a single input field.

The Easy Way: Multiple Values in One Field

What was once 10 lines, is now 2 lines of clean and concise filtering conditions. Here is how it could be done the slow way, using individual filters.

The Long Way: One Value Per Row

Next, use the grouping function to sort players by their position.

There are 2 minutes left on the clock, so spend this time playing around with other filters. Already had your Quarterback and Offensive Linebacker picked out? No worries, filter out those two positions. Filter to include players who went to your alma mater, or more importantly, exclude players who went to the rival school.

And… TIME! Now that you have your dream team, let’s recap the steps we took to get here:

  1. Group by status.

  2. Filter out inactive players.

  3. Filter to include players who were born in the South.