Company & Product
Jul 19, 2022

Multi-Value Filters 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.

Sign Up for Free

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.

Gigasheet UI

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.
  4. Group by position.
  5. Add additional filters like excluding Quarter Backs (QB) and Offensive Linebackers (OLB).
  6. Win this year’s Fantasy Football trophy and credit Gigasheet in your acceptance speech (Again, not required.. but strongly encouraged)

Join our newsletter and be the first to know when we release exciting new additions to our filter tool. If you think multi-values are great, you will LOVE what we have up our sleeve next!

You can do all of this for free. Get started today!

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free

Similar posts

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.