If you are not yet aware, Google Sheets has a new feature called the Slicer. This will come in handy when you need to see individual entries but have to automatically hide entries that do not fit a certain criterion. To add a Slicer, click Data in the main menu and then click Slicer on the drop-down menu that will appear.
A small floating widget will appear on the sheet. When you click on the widget, a sidebar will appear on the right side. You have to select the column you will use to filter the data. Click on the drop-down box below the Column label. A list of column labels will appear (corresponding to the column headers you placed). Select one.
Filter by Value
For our example, we first selected the date column. When we click on the inverted triangle symbol on the left end of the slicer widget, a drop-down menu will appear, with the Filter by value open by default.
Below the filter by values, a list of existing values under the column appears, with all values checked. If we want to display only entries for June 29, uncheck all the other values and then click Ok.
The sheet will look like this:
Note the jump in numbering from row 46 to row 534. It works even if the rows of the same value do not appear in succession. For example, if we want to list only orders of a 12-egg set, the result will look like this:
Filter by Condition
More sophisticated filtering can be done if we select Filter by condition instead of Filter by value.
The filter by condition allows you to filter strings, dates, and numbers.
Let’s say we want to filter out individual orders less than $60.00. To do so, we first set the selected column toone corresponding to the total price, and then on the slicer widget, we select Filter by condition. Afterward, we click on the drop-down box below the Filter by condition, and look for Greater than or equal to option. A box will appear below it after clicking the option. Type in the number, and then click Ok.
Our sheet will look like this:
Further refining your filters
This sounds like an easy job, but that’s because we are dealing with a limited number of filters. Perhaps you need a more powerful data tool that will give you more granular insights...
At this point, we'd be remiss not to bring up our all-in-one data tool, Lido. With a few clicks, you can now access all your relevant business metrics without going through the hassle of finding the data and then slicing every which way to process it. Let our platform do it all for you!
Suscribe to get more data and analytics tips!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.