---
title: "Apply Filtering and Change Interpolation Type"
slug: "apply-filtering-and-change-interpolation-type"
updated: 2024-01-29T12:11:23Z
published: 2024-01-29T12:11:23Z
canonical: "kb.dataparc.com/apply-filtering-and-change-interpolation-type"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.dataparc.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Apply Filtering and Change Interpolation Type

**Purpose:** Learn to apply filtering in a normalized data sheet and to change interpolation types.

**Task:** Add tags to a normalized data sheet. Select a tag to use as the filter tag. Change the interpolation type of the tag to “Min” and then filter all rows where the minimum value is less than a specified value.

**Steps:**

1. Create a new normalized data sheet and add several tags.
2. In the dataPARC panel on the left, set the **Start date** and **End date** to be roughly the last month, rounded down to the nearest hour.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image018_025.jpg)
3. Find the column with the filter tag.
4. Change its **Interpolate** type (row 9) to **Min**.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image020_020.jpg)
5. In the **Filter Min** row (row 6), enter the value to use as the filter.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image022_021.jpg)
6. Set the **Excl Row** (Exclude all Rows setting in Row 8) to **True**.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image024_021.jpg)
7. Click the **Get Data** button.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image026_022.jpg)

Excluded rows are highlighted in gray and data in those cells are not included in the Stats rows for Count, Avg, SD, Min and Max (rows 12 to 16). Notice the filter applies to all tags because Exclude Rows is true.

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image028_021.jpg)