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

# Raw Data Reporting

> Build custom reports across jobs, invoices, payments, timesheets, and 14 other record types, then filter and export the exact fields you need.

FieldPulse's Raw Data Reporting feature allows you to generate and customize reports on your business. Reports can be created on many FieldPulse records, including:

* *Jobs*

* *Estimates*

* *Invoices*

* *Payments*

* *Timesheets*

* *Forms*

* *Projects*

* *Maintenance Agreements*

* *Assets*

* *Customers*

* *Orders*

* *Subtasks*

* *Reminders*

* *Serialized Inventory*

* *Item Usage*

**To learn more about Raw Data Reporting, view the [FieldPulse360 session recording](/training-resources/fieldpulse360/fieldpulse360-archives/fieldpulse360-raw-data-reporting).**

***

# Generating a Report

Begin by navigating to *Reporting* under the Management tab in the left-side menu, then select the record type for which you'd like to generate a report (e.g. *Jobs*). Select *Raw Data*.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/01.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=f9e8739e3545aeb89b1a9538b870665d" alt="Reporting menu with record type selection and the Raw Data option" width="1640" height="1422" data-path="static/images/_api/8931172-raw-data-reporting/01.png" />

Next, you'll need to customize your date range. Click on the calendar icon to select your dates, or use the quick service date options to the left of the calendars. Once you've selected your dates, click *Load Data*.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/02.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=0367354e5586c189b67bfd36232f1304" alt="Raw Data Reporting date range calendar with quick service date options" width="1696" height="928" data-path="static/images/_api/8931172-raw-data-reporting/02.png" />

***

# Customizing a Report

## Filters

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/03.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=8618b38ecb3bad55920ebfe7344b0577" alt="Raw Data Reporting Filters panel for filtering the dataset by field" width="204" height="82" data-path="static/images/_api/8931172-raw-data-reporting/03.png" />

This functionality allows you to filter your dataset on any field on the record. For example, you can filter to see only invoices that have been invoiced but not yet paid.

## Groupings

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/04.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=7f522f31b74eb2c2f3b0e984ef281f5b" alt="Raw Data Reporting Groupings area for grouping columns by unique values" width="638" height="88" data-path="static/images/_api/8931172-raw-data-reporting/04.png" />

This functionality allows you to drag a column or multiple columns in order to group the data in that column by unique values. For example, if you selected the customers column to be grouped, the data would be grouped under each unique customer.

## Quick Reports

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/05.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=f8ad64807bdc2ce8ba2f4348f0f4e629" alt="The Quick Reports panel in Raw Data Reporting with standard data parameters" width="290" height="106" data-path="static/images/_api/8931172-raw-data-reporting/05.png" />

This functionality allows you to quickly display a data report using a combination of standard data parameters than are commonly used to build reports. For example, you can quickly create a report for the total commission received each week grouped by the team member that received the commission.

## Columns

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/06.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=9761f1bd39d87613084677db96438c56" alt="The Columns selector for choosing and ordering report table columns" width="220" height="102" data-path="static/images/_api/8931172-raw-data-reporting/06.png" />

This functionality allows you to select which columns to display in your data table and in which order to display them.

## Pivot Table

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/07.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=0074cb5207987ebee184df14a2a8d3fd" alt="The Pivot Table builder for custom data reports" width="242" height="92" data-path="static/images/_api/8931172-raw-data-reporting/07.png" />

We encourage you to explore the quick reports mentioned above, as they provide a straightforward way to access essential data. For those looking for more customization, pivot tables are an advanced option that allows you to create even further tailored reports. This powerful tool enables you to summarize and analyze large datasets quickly and easily. With pivot tables, you can transform complex information into clear, understandable segments, making it easier to identify trends and insights. Think of a pivot table as a way to rearrange your data, allowing you to view it from different perspectives. Instead of sifting through long lists of numbers, a pivot table helps you group and summarize data to highlight the most important information.

***

# Saving a Report

## Save as Report

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/08.jpg?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=b196ee63e884024a02456e70a26da91b" alt="The Save as Report options with Save as New for naming a report" width="636" height="200" data-path="static/images/_api/8931172-raw-data-reporting/08.jpg" />

* **Save as New:** This will save your report under *Select Report* for easy access in the future. You will need to title and save your report.

* **Save as Widget:** This will save your report as a widget which can be added to your customized *Pulse Dashboard* in the future. You will need to title and save your widget.

## Export CSV

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/09.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=29513f18875c51b8d1a82b48a9e704b0" alt="The Export CSV button for downloading the current report" width="236" height="94" data-path="static/images/_api/8931172-raw-data-reporting/09.png" />

This will initiate a download of the report currently displayed on your screen as a CSV file to your device.

***

# Building Visual Reports

Begin by navigating to *Reporting* under the Management tab in the left-side menu, then select the record type for which you'd like to generate a report (e.g. *Jobs*). Select *Raw Data Beta*.

Next, you'll need to customize your date range. Click on the calendar icon to select your dates, or use the quick service date options to the left of the calendars. Once you've selected your dates, click *Load Data*.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/10.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=90d0f3feff69a0df791ca3371e4987f6" alt="Click on Raw Data" width="1200" height="426" data-path="static/images/_api/8931172-raw-data-reporting/10.png" />

Customize your report using filters, groupings, and columns. When you're satisfied with your report, highlight the fields you'd like to be included in the visual report.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/11.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=b272c8d2335406277a17b26109c3ef78" alt="Right click on Press SPACE to select this row." width="1200" height="795" data-path="static/images/_api/8931172-raw-data-reporting/11.png" />

Right click in the highlighted area, then hover over *Chart Range*. You can now select the visual report type you'd like to use.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/12.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=c530a08d81ebdc190b28758277b7b05d" alt="Click on SubMenu" width="1200" height="795" data-path="static/images/_api/8931172-raw-data-reporting/12.png" />

Use the *Settings* tab to adjust the report type and color scheme of your visual report.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/13.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=eaed6eeb172298ea66709464e318e6e8" alt="Click on Settings" width="1200" height="795" data-path="static/images/_api/8931172-raw-data-reporting/13.png" />

Use the *Data* tab to adjust which categories are displayed on your visual report, as well as which fields are excluded.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/14.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=d9ea0d2f70ba14549ea985884c8b996b" alt="Click on Data" width="1200" height="795" data-path="static/images/_api/8931172-raw-data-reporting/14.png" />

Use the *Format* tab to adjust the report appearance, including font type, font size, and legend specifics.

<img src="https://mintcdn.com/fieldpulse/PNzJA6sOeuas83Gt/static/images/_api/8931172-raw-data-reporting/15.png?fit=max&auto=format&n=PNzJA6sOeuas83Gt&q=85&s=1ef27d30204a1c2945c5b2f452cc68bb" alt="Click on Format" width="1200" height="795" data-path="static/images/_api/8931172-raw-data-reporting/15.png" />

**To learn more, watch the [FieldPulse360: Reporting Upgrades session](/training-resources/fieldpulse360/fieldpulse360-archives/fieldpulse360-reporting-upgrades).**

***

# Video Tutorials

<Frame>
  <iframe src="https://www.loom.com/embed/437e2f91c48142ee959051d74cc1a458?hide_owner=true&hide_share=true" title="Video" className="w-full rounded-lg" style={{aspectRatio: "16/9", border: "none"}} loading="lazy" allow="fullscreen" allowFullScreen />
</Frame>

<Frame>
  <iframe src="https://www.loom.com/embed/a74a2cd274c84d9a80827b304d8fe094?hide_owner=true&hide_share=true" title="Video" className="w-full rounded-lg" style={{aspectRatio: "16/9", border: "none"}} loading="lazy" allow="fullscreen" allowFullScreen />
</Frame>

**To learn more about Raw Data Reporting, view the [FieldPulse360 session recording](/training-resources/fieldpulse360/fieldpulse360-archives/fieldpulse360-raw-data-reporting)\*\*\*\*.**

***

**Have additional questions?**

*Contact us at [support@fieldpulse.com](mailto:support@fieldpulse.com) or use the chat feature in the bottom right corner of your screen.*
