# Filters and time frames in reports

> Use Data as of, date range filters, automatic filters, and parameters to scope report data.

Filters and time frames determine which records a report shows. The time frame sets the period of time you’re analyzing, while filters scope the report to a specific set of records.

## Change the time frame in a report

When you create a report, one of the first things you should adjust is the period of time over which you’re analyzing data. Field filters that are not part of the time frame are covered in [Filters](https://developer.rippling.com/documentation/rippling-platform/reports/filters#filters). There are two ways to adjust the report time frame:

-   Use the _Data as of_ setting to determine whether current or past _Employee_ field values are displayed.
-   Apply date range filters to determine what data is included in the report.

### See historical values using _Data as of_

By default, reports show the most current values in Rippling. However, there may be times you want to view historical values. For example, you may want to see what people’s levels were at the beginning of the calendar year.

To do this, adjust the _Data as of_ setting to a past date. For example, if you select January 1, 2025, the report will show what the values were as of January 1, 2025.

Note that you’ll only be able to see historical values for fields from the _Employee_ object in your report. For example:

-   If you include annual compensation and set the time frame to today, you’ll see each employee’s current annual compensation.
-   If you change the report time frame to one year ago, you’ll see what the employee’s annual compensation was on that date.

Fields from other objects will not show historical values even if you change the _Data as of_ to a past date. For example:

-   If you include the _Document name_ field and set the _Data as of_ to today, you’ll see the name of each document.
-   If you change the _Data as of_ to one year ago, you’ll still see the current name of each document. If a document had a different name one year ago, that name won’t be reflected in the report.

## Apply a date range filter

You can also use any date field to filter a report. Date range filters determine what data is included in the report. For example, add the _Start date_ field and use it to filter your report to people who started in the current calendar quarter.

Rippling automatically adds date fields as filters to some reports. For example, when you add payroll data to a report, a filter using _Pay run check date_ is automatically added. By default, it is set to the last 3 months.

### Example: Report that uses both _Data as of_ and date range filters

When your report includes fields from the _Employee_ object, the _Data as of_ setting and your other date range filters work together to determine what’s displayed in the report.

For example, say you have a report that includes both payroll data and employee titles.

When you add payroll data, a filter using _Pay run check date_ is automatically added to the report. By default, it’s set to the last 3 months. There will be one row in the report for each pay run check date that occurred in the past 3 months.

Adjusting this filter will change how many rows appear in the report.

The _Data as of_ setting determines what is displayed in the _Title_ field. By default, it’s set to today. The _Title_ field will display each person’s title as of today.

If you change the _Data as of_ setting to a date in the past, it will show what each person’s title was as of that date.

## Filters

After you add data to a report, you can add filters to scope your report to the specific set of records you want to analyze. For example, you could filter on the _Department_ field to include only people in the Sales department in your report.

Date range filters are part of the time frame. They are covered in [Change the time frame in a report](https://developer.rippling.com/documentation/rippling-platform/reports/filters#change-the-time-frame-in-a-report).

### Expand and collapse the filters panel

Filters are located across the top of the report. You can expand and collapse the top panel of the reports screen by clicking on **Filters**. A badge continues to show how many filters are in use on the report.

### Add a filter

To use a field as a filter, it must be present in the _Selected fields_ area of the report.

There are three methods you can use to add a field as a filter.

-   Method 1: Add a field to body of the report, then use it as a filter
-   Method 2: Drag a field to the filters area
-   Method 3: Use the filter icon in the _Available data_ panel

#### Method 1: Add a field to body of the report, then use it as a filter

This method lets you add the field to the body of your report and then use it as a filter.

1.  Drag the field to the area where you want it to be displayed (columns, grouping, etc.). The field will automatically be added to the _Selected fields_ area.
2.  Click **\+ Add filter** at the top of the report.
3.  Select the field you just added.
4.  Set the filter criteria.

#### Method 2: Drag a field to the filters area

This method lets you use a field as a filter without displaying it in the report.

1.  Drag the field from the _Available data_ panel directly into the filters area at the top of the report. The field will automatically be added to the _Selected fields_ area, but will not be added to the report display.
2.  Set the filter criteria.

#### Method 3: Use the filter icon in the _Available data_ panel

This method also lets you use a field as a filter without displaying it in the report.

1.  Click the filter icon next to the field name in the _Available data_ panel.
2.  Set the filter criteria. The field will automatically be added to the _Selected fields_ area, but will not be added to the report display.

### Automatic filtering

As you add data to your report, you’ll notice that some filters get added automatically. Rippling adds filters as a convenience based on some assumptions about what you most likely want to see in your report.

For example:

-   When you include the _Employee_ field in reports, they’re filtered to include only people with an _Employment status_ of _Active_.
-   When you add fields that will cause a large amount of data to be added to your report, a filter may be added to limit the time period covered in the report. For example, if you add any data from payroll, a filter is automatically added that limits the amount of data included to the last 3 months.

You can change these default filters as desired.

### Add a dynamic filter based on your reporting structure

There may be times when your permissions give you access to more data than you want to view in your report. For example, if you’re a full admin, you may want to run a report that shows upcoming time off just for your direct reports rather than across the entire company. Likewise, you may want to share a report and be certain that the report viewer only sees information for their own team, even if their permissions give them broader access.

To filter the report based on your company’s reporting structure, use dynamic people filters.

1.  Add the desired person field, such as Manager, Recruiter, etc., as a filter.
2.  Select any of the checkboxes labeled **Dynamic** to apply a filter that uses your reporting structure. You can filter the report to include just the report viewer, the viewer’s direct reports, or the viewer’s direct and indirect reports.

There are a couple of cases where dynamic people filters won’t be available:

-   Some people fields may contain more than one person. For example, there can be multiple _Secondary recruiters_ on a job requisition. If that’s the case, dynamic people filters won’t be available.
-   If there is no data in the people field you select for your report, either because there is no data populated in Rippling or because the report time frame doesn’t include any data, dynamic people filters won’t be available. If you think data should be present, check your report time frame.

### Remove a filter

To remove a filter from your report, click the X on the filter. This will remove the filter, but the field will remain in the _Selected fields_ area of the report.

## Parameters

Parameters let you create custom controls to filter a report or dashboard. Parameters are especially useful if you have a dashboard with multiple reports, and there are standard filters you want to apply across the board. By writing a custom formula, you can automatically update multiple fields, dynamically updating all of the reports with a single control at the dashboard level.

For example, if you have a sales activity dashboard with multiple metrics, you could use parameters to swap the view by sub-region, region, country, or manager.

After you add the parameter, whenever a report containing it is added to a dashboard, the parameter becomes available as a dashboard filter. If multiple reports use the same parameter, adding it as a dashboard filter will update all of the reports in the dashboard.

### Create a parameter

1.  With your report open for editing, hover over _Parameters_ in the _Available data_ panel and click the **\[+\]** icon.
2.  Give the parameter a **Name**. This name will appear as the label on the parameter, both within the report and when using it as a dashboard filter.
3.  Select the **Data type** for the expected output.
4.  In the **Value from** field, define the values that should be shown in the parameter:
    -   **Custom list**. Select this to type in the values you want to use; for example, daily, weekly, monthly.
    -   **Existing field**. Select this to use a field from the Rippling data catalog; for example, _Employment type name_. Optionally select the default value.
5.  For **Share settings**, select the visibility of the parameter:
    -   **Local**. Available only in this report.
    -   **Private**. Available in all reports you own.
    -   **Public**. Available in all reports at your company. Other people will be able to add the parameter to their reports.
6.  Click **Save**.

The parameter is saved, but it’s not yet functional in the report. Continue to the next step to define the logic for the parameter.

### Write an RQL formula defining the logic

Write an RQL report formula containing the parameter logic. The formula will reference the parameter you configured above and use it to determine the output in the report when each parameter has been applied.

#### Example 1: Multiplier for what-if scenarios

Create a formula that uses a number multiplier to run what-if scenarios on salary calculations.

-   Multiply _Annual base compensation_ the _Multiplier_ parameter value of 1 to see the baseline.
-   Multiply _Annual base compensation_ by the _Multiplier_ parameter value of 1.1 to see a 10% increase.
-   Multiply _Annual base compensation_ by the _Multiplier_ parameter value of 1.2 to see a 20% increase.

#### Example 2: CASE statement to set a time period

This formula uses a CASE statement to define the logic for a parameter called _Time Period_.

-   If the _Time Period_ is set to **Daily**, then convert the _csat\_response\_created\_at_ field to show the day.
-   If the _Time Period_ is set to **Monthly**, then convert the _csat\_response\_created\_at_ field to show the month.
-   Otherwise, update the _csat\_response\_created\_at_ field to show the week.

### Edit a parameter

If you want to change a parameter, hover over _Parameters_ in the _Available data_ panel and click the **pencil** icon next to the parameter. You can change its settings, including its visibility. Changes you make to private or public parameters will not be applied to existing reports where they’re being used, but they will be available whenever you add the parameter to a new report.

## See also

-   [Get started with reports](https://developer.rippling.com/documentation/rippling-platform/reports/getting-started)
-   [Joins in reports](https://developer.rippling.com/documentation/rippling-platform/reports/joins)
-   [Write a custom SQL query in a report](https://developer.rippling.com/documentation/rippling-platform/reports/custom-sql)
-   [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization)
-   [Configure drilldown reports](https://developer.rippling.com/documentation/rippling-platform/reports/drilldowns)
-   [Apply formatting to numbers or dates](https://developer.rippling.com/documentation/rippling-platform/reports/formatting)
-   [Overview of dashboard filters](https://developer.rippling.com/documentation/rippling-platform/dashboards/filters)
-   [Share and download reports](https://developer.rippling.com/documentation/rippling-platform/reports/sharing)

Source: https://developer.rippling.com/documentation/rippling-platform/reports/filters

> For the complete documentation index, see [llms.txt](https://developer.rippling.com/llms.txt). Public pages have a Markdown version at the same URL with .md added.
