# Report Builder

## 1 - Creating a Report

1. Name your report. 
2. Select what type of report you would like to create. 

   I selected Aggregation Report to help those who would like to do Rolling Reports.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2F6F9Hapw5OIXWAyt8Ni3x%2FScreenshot%202023-11-02%20at%2012.34.06%E2%80%AFPM.png?alt=media&#x26;token=d4ad3bb5-58aa-4ac9-93c5-c7c866ad205c" alt=""><figcaption></figcaption></figure>

3. Choose the type of chart you want the report represented as.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FW2h3XYe5Vrk9Z1fiKUIG%2FScreenshot%202023-11-02%20at%2012.36.48%E2%80%AFPM.png?alt=media&#x26;token=9c0cf87a-0e50-420a-92b0-5476d7667b4e" alt=""><figcaption></figcaption></figure>

4. Select the Entity which you are creating the report. I chose "Ticket" due to the report being based on closed tickets per Admin.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FrR0jgBqVncSxnreYITkj%2FScreenshot%202023-11-02%20at%2012.37.15%E2%80%AFPM.png?alt=media&#x26;token=bf00b521-d6d2-4958-86d7-b71f3276420c" alt=""><figcaption></figcaption></figure>

5. Under "Method" I chose "Count Occurrence" so the system tallies all the counts for the "Field".

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2F06NfzkEHGS3GT5k4LkRr%2FScreenshot%202023-11-06%20at%2010.35.59%E2%80%AFAM.png?alt=media&#x26;token=389bd10d-f94a-4a41-a34b-8a39c747ea7a" alt=""><figcaption></figcaption></figure>

6. Select your "Field". Here I chose "ID", this is what our tickets are based on.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FI2X3DSbS2J45vWjH9k63%2FScreenshot%202023-11-02%20at%2012.37.53%E2%80%AFPM.png?alt=media&#x26;token=89366c67-6721-47a8-a948-730d6555a192" alt=""><figcaption></figcaption></figure>

7. Select your "Based On".

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Fcc9bSB9aA9CN0kcFhqVr%2FScreenshot%202023-11-02%20at%2012.38.05%E2%80%AFPM.png?alt=media&#x26;token=fe55d180-ed5b-4d68-9be3-0dc25194021c" alt=""><figcaption></figcaption></figure>

8. Select the Order of your chart, then add "Search Conditions".

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FjsF1aDM7wnzju8FO2OuG%2FScreenshot%202023-11-02%20at%2012.38.32%E2%80%AFPM.png?alt=media&#x26;token=da767b09-0603-4d47-b18c-5aa90610e6cb" alt=""><figcaption></figcaption></figure>

Select "+And". When you click on the first drop down, the  menu list shows the following options.&#x20;

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Fae7TkkxLtva1WMhrCWQC%2FScreenshot%202023-11-06%20at%208.41.50%E2%80%AFAM.png?alt=media&#x26;token=8bf01dc0-aa8b-4ef1-ac37-d4c99a6eb829" alt=""><figcaption></figcaption></figure>

For the purposes of our demo report, we will continue with the Rolling Report.

9. Select "Admin"
10. In the next dropdown select "Assigned". This will only show tickets that have been assigned to an Admin, and then closed. If you want to see tickets that are not assigned to anyone and are closed, then skip step 9 and 10.&#x20;
11. Select "+Add"
12. In the dropdown select "Created At"&#x20;
13. In the next drop down select "Rolling Window"

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FB9kQdzluzKsIfAHH2U3T%2FScreenshot%202023-11-06%20at%208.43.15%E2%80%AFAM.png?alt=media&#x26;token=5e42c2db-4f3f-4391-8043-8ef3c27e3f3a" alt=""><figcaption></figcaption></figure>

14. Input the number of days you would like the window to be open.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Fcr10pKakYHQxnCctuYbO%2FScreenshot%202023-11-06%20at%208.43.30%E2%80%AFAM.png?alt=media&#x26;token=39013d58-f6af-4806-86fe-76abf567316f" alt=""><figcaption></figcaption></figure>

15. Select "+ And" ("+ And" means required logic) \*Selecting "+ Or" would mean optional logic.
16. Select "Status" from the menu.
17. Select "Exact Match"&#x20;
18. Select "Closed", this refers to all closed tickets.&#x20;

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FMB3mof0kPmBVLVPDaKVo%2FScreenshot%202023-11-06%20at%208.43.59%E2%80%AFAM.png?alt=media&#x26;token=36bf8342-328f-4ccd-8c51-97d589a693e8" alt=""><figcaption></figcaption></figure>

If you want your report to be for you only, then you can click "Save". If you would like your report to be open for anyone with permissions to see the report, click the box to share and make public for your users. Make sure you click "Save" after you click the share box.

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Ft1ngMgh5E7tNMmsMtpyp%2FScreenshot%202023-11-06%20at%208.45.24%E2%80%AFAM.png?alt=media&#x26;token=9df311d3-9ec9-4efe-9b69-0f16cce53e00" alt=""><figcaption></figcaption></figure>

## 2 - What Do the Menu Items Mean?

<figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FAw8ShuHElN5M09hkRugx%2FScreenshot%202023-11-06%20at%209.33.44%E2%80%AFAM.png?alt=media&#x26;token=757f2bbc-2cc3-4c28-a555-cc9558713bde" alt=""><figcaption></figcaption></figure>

1. Exact Match - Item or value must match exactly with no variation. ![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Fqj1OIVDHSg1lmslUAIyk%2FScreenshot%202023-11-06%20at%209.45.33%E2%80%AFAM.png?alt=media\&token=e92bd983-daa7-4e59-afc8-b83f3f60bf36)
2. No Exact Match - Any Item or value excluding the one provided.
3. Greater Than - Any number larger in value than the one given. ![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2Fr7fqy2BVGKpVkSRDiVGF%2FScreenshot%202023-11-06%20at%209.48.58%E2%80%AFAM.png?alt=media\&token=9e2d389d-8af1-4973-982c-a9b768f8596a)
4. Greater Than or Equal - Any number larger than, or equal in value to the one given.
5. Less Than - Any number smaller in value than the one given.
6. Less Than or Equal - Any number smaller than, or equal in value to the one given. ![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FkXcO2sQWmna9TFEPbqdN%2FScreenshot%202023-11-06%20at%209.49.04%E2%80%AFAM.png?alt=media\&token=77048ca8-6ed1-4f4f-aaa9-bc5b14f8e566)
7. Between - Any value in between 2 given values, that you choose. ![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FrySh9F9rNhiriTaquNjn%2FScreenshot%202023-11-06%20at%209.49.09%E2%80%AFAM.png?alt=media\&token=3e299cbe-0874-414c-b3a9-88c8df584d21)
8. Not Between - Any value not in between 2 given values, that you choose.
9. In - All entries in the field which you choose. Make sure that you hit enter to apply the entries. ![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FmvvxkmEJqvcJCWWtgHN5%2FScreenshot%202023-11-06%20at%209.43.37%E2%80%AFAM.png?alt=media\&token=f83bde3b-1fa3-4a25-9152-898cc93fd05d)![](https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2F8nZSWXsjAxf2bNqyQsqb%2FScreenshot%202023-11-06%20at%209.43.00%E2%80%AFAM.png?alt=media\&token=67fbf46c-31df-4783-b9c3-651c1ec69b5c)
10. Not In - All entries outside the field in which you choose. Make sure that you hit enter to apply the entries.&#x20;
11. Rolling Window- All entries within a given window will be updated to reflect the value. EX: A rolling window of 30 days will update daily to reflect the last 30 days from the calendar date.&#x20;

    <figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FvOBvW5mzMEKqrUtCtdV2%2FScreenshot%202025-01-30%20at%209.55.07%E2%80%AFAM.png?alt=media&#x26;token=5b267bdb-6bb0-4991-8253-caec9a83c9b7" alt=""><figcaption></figcaption></figure>
12. Rolling Newer- All entries newer than the given value (in days).
13. Rolling Older- All entries older than the given value (in days).&#x20;

    <figure><img src="https://886837371-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FqzQlqY7NPM9yObejMJmK%2Fuploads%2FcGMYVUZoMeYU01iQsrj1%2FScreenshot%202025-01-30%20at%209.56.15%E2%80%AFAM.png?alt=media&#x26;token=c78878ca-9f59-4a85-a54a-2f946a135148" alt=""><figcaption></figcaption></figure>