# Get started with reports

> Rippling reports let you analyze employee data, app activity, custom apps, and imported data.

Rippling reports let you analyze your data to help you better understand your business. You can build reports using any of your data in Rippling, including your employee data, data about the activity in your Rippling apps, data captured using custom apps, and data imported from your third-party business systems.

There are three ways to create reports:

-   **Use Rippling AI to build a report**. Enter your prompt and Rippling AI will automatically build a report that meets your requirements. You can chat with Rippling AI to iterate on the report until it looks the way you want.
    
    > **Note:**
    > This is only available with a Rippling AI subscription.
    
-   **Use a report recipe**. Report recipes are templated, pre-built reports that can be loaded with a couple of clicks and then customized as much or as little as you like.
    
-   **Build your own report**. Build a report from the ground up, bringing in the data you want to see and designing the layout and visualization to meet your needs.
    

Your permissions determine which recipes you can use and what data you can include in reports. For more information, see [Report permissions](https://developer.rippling.com/documentation/rippling-platform/reports/permissions).

## Get acquainted with the Reports and Dashboards app

To get started with reports, open the sidebar and select **Data** > **Reports and Dashboards**.

### Tabs in the Reports and Dashboards app

The Reports and Dashboards app has the following tabs:

-   **Recent**. Reports you’ve recently viewed.
-   **Created by me**. Reports you’ve created or whose ownership has been transferred to you.
-   **Shared with me**. Reports that other people have shared with you.
-   **Report access**. Lets super and full admins see who at the company has access to which reports.

### Reports editor

The reports editor is where you’ll design your report. There are four main sections:

1.  **Available data**. This is where you’ll find and select data to add to your report. Depending on your permissions, you’ll see data related to your employees, your Rippling apps, and any custom or imported data.
2.  **Configuration**. This is where you’ll adjust the layout and formatting of the report and configure any drilldowns.
3.  **Filters & controls**. This is where you’ll manage the filters that narrow down the data in your report.
4.  **Report content**. This is where the report itself is displayed. The report content is updated in real time as you make changes.

As you make changes in the reports editor, use the **Undo** and **Redo** options in the top right corner to revert changes or add them back.

## How to create a report

To create and save a new report, follow these steps:

1.  From the sidebar, select **Data** > **Reports and Dashboards**.
2.  Click the **New Report** button.
3.  Select a report recipe or click **Start from scratch** to build your own customized report.
4.  Select your desired **chart type**. You can select from the following options:
    -   **Grid**. Displays data in a table with columns and rows. You can optionally aggregate the data by grouping the rows together.
    -   **Pivot table**. Presents aggregated data in a tabular format, letting you see and compare values side-by-side.
    -   **Chart**. Select any of the available chart types to display data graphically, such as bar chart, line chart, funnel chart, or scatter chart.
5.  Add data to the report. From the _Available data_ panel on the left, drag fields and drop them directly into the section where you want them displayed, such as columns, rows, grouping, X axis, etc.
6.  Adjust the other settings in the report as needed, such as the time frame, filters, aggregation, and sorting. Time frames and filters are covered together in [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters). Aggregation, sorting, and display settings are covered in the sections below.
7.  Once you’re happy with your report, rename it by clicking the **edit** icon next to the name, then click **Save**.

Your report is saved and will appear at the top of the _Recent_ and _Created by Me_ tabs.

## Refine the data in your report

You can use the following options to refine the data in your report. Time frames and filters are covered together in [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters).

-   Select the report time frame
-   Apply filters
-   Adjust the joins
-   Write a custom SQL query
-   Group and aggregate the data
-   Change the grouping depth
-   Bucket by time period
-   Select the target currency
-   Select the target time zone
-   Configure drill-down reports

### Set the report time frame

One of the most important elements of your report is the time frame over which you're analyzing data.

There are two ways to adjust time period for data used in the report:

-   **Set the _Data as of_**. Use the _Data as of_ setting to set the baseline date for the report. By default, it’s set to today to show the most current values. However, if you change this to January 1, 2025, the report will show what the values were as of January 1, 2025.
-   **Apply a date range filter**. Use any date field to filter 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.

For more information, see [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters).

### Apply filters

Filters let you narrow down the data in your report. For example, you could filter a report to include just people in certain departments or work locations, devices with a particular OS version, or pay runs in a given status.

For more information, see [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters).

### Adjust the joins

If your report uses data from multiple datasets, you may want to change the way it’s joined. For example, you could change the join from a left join to an inner join to limit the dataset to only employees with values in both datasets.

For more information, see [Joins in reports](https://developer.rippling.com/documentation/rippling-platform/reports/joins).

Note that the ability to change how the data is joined is not available in a select set of report recipes, as noted in the “Special report recipes” section below.

### Write a custom SQL query

You can write SQL in a report to generate new fields. You can then join those fields with the other data in your report. You can only add one SQL query to a report. The query is saved only within the report where you created it.

For more information, see [Write a custom SQL query in a report](https://developer.rippling.com/documentation/rippling-platform/reports/custom-sql).

### Group and aggregate the data

If you’ve selected a **grid** as your layout, you can consolidate the data in your report by adding grouping. For example, if you have a report listing each person’s annual base compensation and you’d like to see a department total, you can group the report by department to automatically generate a sum for each department.

If you’re using a **pivot table** or **chart** layout, the data is automatically grouped and aggregated as you design your report. You can then update the aggregation settings as desired by clicking the three dots on the field name and selecting your preferred aggregation method.

For more information, see [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization).

### Change the grouping depth

For data points that have a hierarchy, such as department or manager, you can change the grouping depth.

When your report is grouped using a field that has a hierarchy, such as department or manager, you can change the grouping depth. This lets you select the level in the hierarchy you want to group by, the most specific (or lowest) level, all levels, or a particular level of your choosing.

To do this, click the three dots next to the field name and select **Grouping depth**.

For example, say your company has an Engineering department with sub-departments for Backend, Frontend, and Infra, and you have a report that is grouped by department:

-   When you select **Most specific** as the grouping depth, the report displays the _Backend_, _Frontend_, and _Infra_ departments as the rows.
-   When you select **All levels** as the grouping depth, the report displays _Engineering_ as a row, with nested rows for _Backend_, _Frontend_, and _Infra_.

### Bucket by time period

When your report is grouped by a date or time field, you also have the option to choose an interval, or bucket, for the grouping, which allows you to create a time series of data. For example, if you group payroll data by check date, you can then bucket your data by year and month to produce a monthly time series.

To do this, click the three dots next to the field name, select **Bucket by**.

For more information, see [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization).

### Add report formulas

If you want to create a custom calculation, you can do so by adding a report formula. Report formulas let you use Rippling’s proprietary query language RQL to calculate new values using the data in your report. For example, you could add a field that automatically calculates total compensation by writing a formula that sums annual base compensation and target annual bonus.

### Select the target currency

If your report contains monetary values, you can convert them to any currency supported by Rippling. To do so, click the three dots in the top right corner of the report and select the desired currency.

For more information, see [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization).

### Select the target time zone

If your report contains date or time values, you can convert the time zone used in the report. To do so, click the three dots in the top right corner of the report and select the desired time zone.

### Configure drilldown reports

If your report includes aggregated data, you’ll be able to click on an aggregated value and drill down to the details behind it. You can customize the contents of these drilldown reports to show the details you want to see.

To do so, select the **Settings** tab, then select **Drilldown**. From here, you can add and remove fields in the drilldown report. Then, click into an aggregated row of the report to open the drilldown, where you can customize filters and other settings.

For more information, see [Configure drilldown reports](https://developer.rippling.com/documentation/rippling-platform/reports/drilldowns).

## Change the display and formatting of your report

You can use the following options to change the display and formatting of your report:

-   Sort the data
-   Customize field display names
-   Change the formatting of numbers, currencies, and dates
-   Apply conditional formatting
-   Change the row density
-   Configure a pivot table
-   Adjust chart settings

### Sort the data

You can change the way the data in your report is sorted (ascending or descending order) by clicking on the three dots next to the field name, then selecting **Sort**.

### Customize field display names

You can customize the display name for any field used in the report. For example, if your report contains the field _Annual base compensation_, you could shorten it to _Comp_ in the report.

To do so, click the three dots next to the field name and select **Rename**.

Note that the name of the field will remain unchanged in the _Selected fields_ area. Only the display name will change.

### Change the formatting of numbers, currencies, and dates

Select your preferred format for numbers and currency values. To do this, select the three dots on the field name or click the down arrow in the column header, then select **Number formatting** or **Date formatting**.

For more information, see [Apply formatting to numbers or dates](https://developer.rippling.com/documentation/rippling-platform/reports/formatting).

### Apply conditional formatting

Add conditional formatting to use color to highlight values that meet specific criteria. For example, shade all cells with titles that contain the title “Coordinator” red, apply different colors to each unique value in the table, or apply a color spectrum across a range of values.

To add conditional formatting, click the three dots next to the field name, then select **Conditional formatting**.

### Change the row density

You can adjust the spacing of the report rows to optimize for readability vs. information density. To do so:

1.  Select the **Settings** tab.
2.  Select **Configuration** in the menu.
3.  Select your preferred **Row density**.

## Share and download reports

After you create a report, you can save it for future use, share it with your colleagues in Rippling, and download it for offline reference.

For more information, see [Share and download reports](https://developer.rippling.com/documentation/rippling-platform/reports/sharing).

## Special report recipes with limited capabilities

There are a few special report recipes in Rippling that do not have the same full set of capabilities as most reports:

-   Talent retention rate
-   Time & Attendance change history report
-   Automation Studio triggered events report
-   Automation Studio triggered actions report

When you use these recipes, your options for customizing the report may be limited.

## How quickly updated data shows up in reports

When you create a new report or open a saved report, nearly all the data in the report is queried, which means most of the report data is updated, but there are a few circumstances where data is updated on a specific schedule.

### Refreshing the data in custom reports

The information in custom reports is cached for two hours. This means that if the data in Rippling changes and you have the report open, the data won’t be updated for two hours.

There are two ways to manually refresh the data:

-   Change the report time frame or employee filters and then re-run the report.
-   Click the **Refresh data** icon. You can refresh the data this way once per minute.

### Employee data

Employee data is updated in reports within 15 minutes of when the change is made. This includes all personal and employment data (name, address, SSN, department, compensation, etc.). If you don’t see the change you expect, wait a few minutes and then try again.

### Time tracking data

It takes 24 hours for timecard changes and job dimension adjustments to process and reflect in reports. If a timecard was updated recently, the changes will not appear immediately.

### Change history reports

The change history report relies on a daily cache for performance purposes, and this cache is automatically reset every night PST. Therefore, the data you see in the change history report only includes changes through the previous day.

## How scheduled and backdated changes are reflected

When you modify employee data within Rippling, you can apply those changes immediately or schedule them to take effect on a future date or as of a prior date. This is often displayed as the **effective date** of a change. The effective date of a change has many effects across Rippling, including how data is reflected in a particular time period within reports.

### Changes that have an effective date in the future

Any changes with a future effective date will not be reflected within reports until the change is applied _on_ the effective date. Therefore, a future-scheduled change will not appear on a report with today's date.

### Changes that are made with a prior effective date

Changes with a backdated effective date, including employee data you've imported from a previous system, will be reflected in reports as of the effective date.

## Why a custom field can be empty

When you populate the value in a custom field, the date that value was populated is also stored in Rippling. You can think of this as the “effective date” for the custom field value. When you run reports that include custom fields, the custom field values will only show up in the report if the date range includes that effective date.

For example, say you have a custom field for collecting driver’s license numbers. You hire a new employee named Paul, and he adds his driver’s license number the day he onboards to Rippling, which is January 1, 2024.

-   If you run a report that shows a **snapshot** of data as of December 15, 2023, Paul’s driver’s license field will be empty. But if you change the date in the report to January 2, 2024, the report will show Paul’s driver’s license number.
-   If you run a report that covers a **range of time** covering December 15 - 31, 2024, Paul’s driver’s license field will be empty. But if you change the date range to cover December 15 - January 15, 2024, the report will show Paul’s driver’s license number.

> **Note:**
> There is a brief 15-minute window when new changes to employee data may not show up in reports. If a custom field you expect to be present is missing from your report, and the field has recently been updated, wait a few minutes and try again.

## Why a retroactive change may not show up as expected

When you make a change to an employee's data, you can schedule when the change goes into effect. This can be any future or past date. If you make a change with an effective date in the past, and then run a report that includes the data, the report will show the updated values as of the date the change was made, not as of the retroactive effective date.

For example, let's say that on May 11, you changed an employee's department from _Mid-market_ to _Marketing_, with an effective date of May 2. You then run a report that includes the employee's department.

-   When you run the report with the _Data as of_ set to May 11, the employee's department will show as _Marketing_.
-   When you run the report with the _Data as of_ set to May 2, the employee's department will show as _Mid-market_.

## See also

-   [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)
-   [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters)
-   [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)
-   [Report permissions](https://developer.rippling.com/documentation/rippling-platform/reports/permissions)
-   [Share and download reports](https://developer.rippling.com/documentation/rippling-platform/reports/sharing)
-   [Get started with dashboards](https://developer.rippling.com/documentation/rippling-platform/dashboards/getting-started)
-   [Permissions for data in Rippling](https://developer.rippling.com/documentation/rippling-platform/data-model/permissions)
-   [Generate and Download Reports Using the API](https://developer.rippling.com/documentation/rest-api/guides/reports)

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

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