Skip to main content

Filter Data

This guide will walk you through the process of filtering data in TableSprint using a store page of used cars as an example. You will learn how to use various filtering options to sort and view your data efficiently.

Step 1

In this tutorial, we will learn how to filter data in TableSprint. To explore the data, we will use a store page of used cars. You will see different columns such as Car, PICS (all the pcitures of car), manufacturing year, kilometer, insurance validity, insurance type, car location, transmission, colors, and registration office.

alt text

Step 2

You will see various photos of the cars that have been uploaded. Note that this is demo data.

alt text

Step 3

To filter the data, click on the filter option. This is the most common method to initiate a data filter.

alt text

Step 4

Upon clicking the filter, you can then click on the condition option and choose all the field names available. You can view various fields such as manufacturing year, kilometer, insurance validity, insurance type, car location, transmission, colors, and registration office.

alt text

alt text

Step 6

The filter will automatically build up. For example, you can specify that the car is not a Brezza Petrol.

alt text

Step 7

Once you apply the filter, it will show you the filtered data based on your conditions.

alt text

Step 8

You can even create filters for conditions such as kilometers greater than 1000.

alt text

Step 9

The advantage of this filter over a normal Excel filter is that you can add multiple conditions using 'and' or 'or'. You can achieve all complex filtering. Also, within a condition group, you can add further filters. For instance, you can specify that the car is not a Swift Diesel.

alt text

Step 10

You can apply various filters for different time frames such as last month, last year, etc. Apart from these advanced filters, a simple search option is also available to search data using normal filters.

alt text

So, it provides greater flexibility in filtering your data. In subsequent tutorials, we will explore more features.