# Customize Reports

Every Shopify business is unique, with its own reporting requirements. Report Pundit recognizes this reality with Custom Report creation. Whether you want to generate a new report from scratch, or modify an existing report, the feature empowers you to gain the data you need for personalized Shopify store insights.&#x20;

## :clipboard: Steps to Create your Customized Report

1. You can find the<img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FRpWQN8tHePuzVTD1faam%2FRP%20create%20report.png?alt=media&#x26;token=33d82a4a-8f3b-4e4d-b093-9834da87305f" alt="" data-size="line">button in two pages: '**Library'** & '**My Reports**' page. Go to either of the pages using our navigation panel on the top, and click on <img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FRpWQN8tHePuzVTD1faam%2FRP%20create%20report.png?alt=media&#x26;token=33d82a4a-8f3b-4e4d-b093-9834da87305f" alt="" data-size="line">
2. **Name** your report. Add a **Report Description** if required, and click on '**Continue**'.

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2Fz9OTXj7N3KOSxhKG4sKd%2Fezgif.com-gif-to-mp4.gif?alt=media&#x26;token=c89964ed-8ade-4dc0-91d0-ccdff4d2a2dd" alt=""><figcaption></figcaption></figure>

3. Select your R**eport Category** from the **13 options** available. Once confirmed, the data fields for that category will be displayed. Click on **Proceed** to continue.

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FouwwrTeoh2jJvVmgW2JR%2Fezgif.com-gif-to-mp4%20(1).gif?alt=media&#x26;token=4e7fa504-dde4-4982-9aee-874d26238fb5" alt=""><figcaption></figcaption></figure>

4. The first report type from the report category will be chosen by defaul&#x74;**.** In case you want to see or change the report type, select the **Report Type,** and choose the Report Type, from the sidebar on the left.

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FDGwrvoU36U1PLT4Jr8HD%2Fezgif.com-gif-to-mp4.gif?alt=media&#x26;token=ecdc11aa-0fb5-4be9-9e03-ba2dfe6dfdd9" alt=""><figcaption></figcaption></figure>

5. Select your desired date range from the several pre-sets using the date selector tab. You can also set custom **start and end dates**.

   \
   For example: In this case, we have chosen the **Last 30 days** optio&#x6E;**.**

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FpDDDzWql0wdZJIsnyyic%2Fezgif.com-gif-to-mp4.gif?alt=media&#x26;token=8948a511-f8c7-4193-9f92-218e7d670233" alt=""><figcaption></figcaption></figure>

6. To create your report, select the data fields you need via the **Select Fields** tab. You can use the **search bar** to quickly locate fields.&#x20;

In this example, the fields selected are *Barcode (UPC), Inventory Quantity, and Price*.

<div align="center"><figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FkFPPZCFqlEtkdNdFdOzO%2Fezgif.com-gif-to-mp4.gif?alt=media&#x26;token=d359d232-6244-4b93-98b6-168556c242b1" alt=""><figcaption></figcaption></figure></div>

7. To save the report, click on the "**Save**" button. You can access your report anytime in the "**My Reports**" page.

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2Fcwb9zlwooa2ImOdHcwqM%2Fezgif.com-gif-to-mp4%20(1).gif?alt=media&#x26;token=d54d854e-6c1b-40eb-839e-938606ec2a79" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
&#x20;:star2: That's it. You've successfully customized your report. &#x20;
{% endhint %}

### **Selected Fields Panel**

You can find the data fields you've added to your report in the left side panel as shown:

<figure><img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FvKrSJmR2YwM0vrTo7Sqv%2FCustom%20Fields%20Panel.png?alt=media&#x26;token=56d56463-3c5c-4f0a-b046-57f347708042" alt=""><figcaption></figcaption></figure>

The panel has a **Report Type** drop-down menu that shows what category your report falls under. You can also change the report type using this column as demonstrated above.&#x20;

This drop-down menu if followed by two columns showing the data fields (columns) included in your report:

* **Numeric Columns**: displays the **numerical data fields** in your report. Ex.: Discount.
* **Text Columns**: displays the **text fields** in the report. Ex.: Product Name

The selected fields are automatically organized in the respective columns. You can manually change this order by simply **dragging and dropping** the field&#x73;***.*** Use the dotted tab to the left of each data field to move it.

### How to Edit A Data Field&#x20;

Place the cursor over a data field and you'll find options to **edit** it.

{% tabs %}
{% tab title="✏️" %}
**Edit**: You can edit the field name by clicking on :pencil2:, typing in the name, and then clicking '**Okay'**.
{% endtab %}

{% tab title="👁️" %}
**Hide**: You can hide the field from the report by clicking on :eye: button. It is useful in case you don't need a calculated field to be shown. This way you do not remove the field, but only hide it.&#x20;
{% endtab %}

{% tab title="🗑️" %}
**Remove:** Click on :wastebasket: to remove the selected field from the report.
{% endtab %}

{% tab title="⁝" %}
**Additional Options**: Click on the  <img src="https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2F4UvWmHQ3Yd7iPFF3EqoN%2Fellipsis-vertical-solid.svg?alt=media&#x26;token=47407d12-79fa-4cd1-a0ed-0e1973705b44" alt="" data-size="line">  button to access other field editing options.

* **Group by:** You can group them according to Value(none), Row, and Column.
* **Aggregate type:** You can add a calculating function to the numerical field. The 'Sum' aggregate '**∑'** is set by default on all numerical fields.
  * ***Sum*** - Gives you a summation of all the records in the field.
  * ***Count*** - Gives you a count of all the records in the field.
  * ***Count Unique*** - Gives you a count of all the unique records in the field.
  * ***Min*** - Gives you the minimum value among the records in the field.
  * ***Max*** - Gives you the maximum value among the records in the field.
  * ***Average*** - Give you the average value among the records in the field.
* **Date Format:** You can change the date format for date fields as shown below.
  {% endtab %}
  {% endtabs %}
