For AI agents: an index of this documentation is at https://developer.rippling.com/llms.txt. Public pages have a Markdown version at the same URL with .md added.

Skip to main content
guide

Filters and time frames in reports

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

Use with AI:Rippling AI ChatGPT Claude Cursor

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. 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.

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​