Step 1: Prepare your data in Google Sheets

Make sure you have your data organized in a spreadsheet in Google Sheets. Each column should represent a different category or parameter that you might want to filter.

To show this in action, we created a sample sales data analysis spreadsheet for different products and regions. The task is to use a slicer to filter the data by product category.

Step 2: Create a Pivot Table (Optional)

If your data isn't already in one, you might want to create a pivot table in Google Sheets. These allow you to summarize and analyze your data more easily. You can create a pivot table by selecting your data and going to Insert > Pivot table.

Since our data is already in a simple tabular format and we only need basic filtering, we’ll skip this step and use slicers directly on the table.

Step 3: Create a slicer box

Click on a cell within your pivot table (or normal table if you're not using a pivot table) to make sure it's active. Next, go to Data in the top menu and click on “Add a slicer” in the dropdown.

A slicer box will appear on your sheet. You can position it wherever you want.

Step 4: Select a parameter or category

Now, you need to select which parameter or category you want to work with. In our example, we will select the Product Name column in the Slicer dialog box as the filter.

The slicer box will automatically update.

Step 5: Click on the “Customize” tab

You can change the slicer box’s title, font, font size, title format, and background color. You also can adjust its size by dragging the colors of the box to increase or reduce it. To move the slicer, click, hold, and drag.

Step 6: Test your data slicer

Click on the striped triangle icon on the slicer toolbar or the “all” dropdown to filter the selected column.

You can filter your data in two ways, as we will explain below.

Step 6.1: Filter by values

This option allows you to filter the data by selecting specific values from the slicer. This is useful when you want to quickly select and display particular items from your data.

In our example, since we have a slicer for "Product Name," we can choose to display data only for "Laptop" and "Tablet" products, and the slicer will adjust the data accordingly. Alternatively, you can use the search bar.

Once you’re done, click on “OK." The table will then show information related to the items you selected.

Step 6.2: Filter by condition

Instead of manually selecting values from the slicer, you can set up specific rules to filter the data. In our example, we can set a condition to display sales data where the Sales Amount is greater than $800.

You can also create slicers for each column so you can sort through data easier.

Step 1: Log in to Softr or create an account

First, log in to your Softr account. If you don’t have an account, sign up to Softr for free.

Step 2: Connect your Google account to Softr

To connect your Google account with Softr, so that the software can access your Google Sheets data, you need to follow the next steps.

Step 2.1: Go to your Application Settings > Data Sources

From the Softr dashboard, click on “new application,” then select “blank application” to build from scratch or choose any template you prefer.

Step 2.2: Click on Google Sheets to select data source

After selecting your preferred option, click on “Connect a Data Source,” then select Google Sheets. Click “Continue” to connect Softr to your Google account.

Step 2.3: Log in to your Google Account

After clicking “Continue,” you’ll be prompted to log into your Google Account, the one where your Google Sheets data is saved.

Step 2.4: Authorize Softr to edit your Google Sheets data

Next, you need to authorize Softr to make changes in your associated account’s Google Drive files, which include your Google Sheets files. To do so, check the checkboxes highlighted below. Then click on “Continue.”

Step 3: Click on the “+” sign to start selecting the Google Sheets you want to work on

In order to select which Google Sheets file you want to use, click on the “‘+” sign.

Step 4: Choose a dynamics block

After clicking the “+,” you'll find a sidebar with various blocks and components. In the dynamic tab of the sidebar, click on any of the list blocks.

Step 5: Choose from which Google Sheet file you want to import the data

In the SOURCE tab, click on the drop-down list under “Source.” There, select your connected Google Sheets account. Next, under “Document,” choose the spreadsheet with the data you want to use. Then, under “Sheet,” select the specific sheet within the spreadsheet you selected to import its data.

Step 6: Click “Conditional Filters” in the List settings sidebar

Scroll down the “Source tab” to find and click on the “conditional filters” option. Then click on the “Add condition” button to define your search criteria, so you can filter and display only the data that matches what you need.

Step 7: Test and optimize

Click on the “preview” button to test and ensure the filter(s) is working well.

Step 1: Select the cell where you want your filtered data to appear and type the QUERY formula

After selecting the cell where you want the results of the QUERY function to appear, it’s time to use the function to extract the data.

In our example, if you wanted to filter the data to show sales data for the Electronics category in the North region, your QUERY formula would look like this: =QUERY(A:D, "SELECT * WHERE A = 'Electronics' AND B = 'North'"), where:

• A:D refers to the range of columns containing your data
• "SELECT *" selects all columns
• "WHERE A = 'Laptop' AND B = 'North'" specifies the conditions for filtering. You can adjust these conditions based on your needs

The function ensures only laptops in the North region are displayed.

Step 2: Perform advanced functions (optional)

You can also use the QUERY function to aggregate data, such as calculating totals, averages, and counts. For example, to find the total sales amount for "Laptop" in the "North" region, your formula is: =QUERY(A:D, "SELECT SUM(D) WHERE A = 'Laptop' AND B = 'North' LABEL SUM(D) ''")

You can also sort the results using the ORDER BY clause. For example, to sort sales data by date in descending order: =QUERY(A:D, "SELECT * ORDER BY C DESC")

‍