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

# Custom Reports

Custom reports can be either created from an existing report or created from scratch, and viewed by everyone with the appropriate reporting permissions. You have the option to directly download reports, send them to an email address, or send them to an SFTP droppoint.

<Card title="Watch: Explore and Modify Reports" icon="circle-play" href="/video/reporting-explore-and-modify-look" horizontal data-rec="video">
  Learn how to explore and customize reports
</Card>

## SFTP Best Practices

If you are using a client-side or third-party SFTP droppoint to receive reports, Kibo recommends following the below guidelines to maximize performance.

* Ensuring access to the SFTP droppoint is the responsibility of the client or third party maintainer. Make sure that Kibo's SFTP user has read and write permissions to the directory, which is required to deliver files.
  * For example, in the command line this may look like `drw-rw-r--` (which means the owner has read/write, the group has read/write, others are read-only)
* Ensure files do not pile up over time. Utilize /archive folders and periodic cleanup of historic data. Monitor the droppoint and clean up files that are no longer needed.
  * If you need to retain the files, archive them to another folder once they’ve been processed.
* Ensure disk space usage is monitored and alerts the maintaining IT team in time to address low disk space situations before causing connection issues for Kibo.

## Create From Existing Report

A Report Editor user can create custom reports by editing an existing report.

1. Click on right top corner of a tile and then **Explore from Here**. <img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-from-here.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=f5c46ca180d58cc67bd1fe90a65a6117" alt="The drop-down option menu of a tile with Explore from Here highlighted" width="968" height="421" data-path="img/explore-from-here.png" />
2. The Explore page displays all current report dimensions and measures. It is possible that this will change the page header to an older version of the UI, but you can still navigate the folder directory and access other options in the top right corner.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-page.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=772eb369efd1a4d16ef26cc367fa76c3" alt="The Explore page showing example order data and the navigation menu in the top right" width="1906" height="836" data-path="img/explore-page.png" />
3. Change fields by pulling dimensions and measures from the left pane into the **Data** section in the right pane.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-fields.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=fcf7dd8f593e58e84b119b6d46fdc463" alt="The Explore page with callouts showing where to move filters to the Data section" width="1893" height="603" data-path="img/explore-fields.png" />
4. You can further configure the Data section by clicking the gear icon on a table and changing settings such as calculations, hiding that data from the visualization, filling in missing dates, etc.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-data-options.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=fadae33c82c48a2edcc0e7672d91afae" alt="The Edit menu of the Data section" width="213" height="322" data-path="img/explore-data-options.png" />
5. Expand the **Filters** section to configure the applied filters.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-filters.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=fb3f60ec258dff16db853ba8ab1c5ebb" alt="The Explore page with a callout for the expanded Filters section" width="1152" height="323" data-path="img/explore-filters.png" />
6. You can further edit the Visualization section by clicking **Edit** on the right and changing the axis, positioning, layout, etc.<img src="https://mintcdn.com/kibocommerce-59e68a4a/fwXJJzJOp-IYCY1g/img/visualization-options.png?fit=max&auto=format&n=fwXJJzJOp-IYCY1g&q=85&s=928d0e466bf7c5238237043d41879a4b" alt="The Edit menu of the Visualization section" width="306" height="264" data-path="img/visualization-options.png" />
7. Click **Run** in the top right to generate the report.<img src="https://mintcdn.com/kibocommerce-59e68a4a/kGarQ_7QDUU5QUsX/img/run-report.png?fit=max&auto=format&n=kGarQ_7QDUU5QUsX&q=85&s=7ca503a0a9eb1f560429078529a40dec" alt="The Explore header with a callout for the Run button" width="430" height="68" data-path="img/run-report.png" />
8. To save the report, click on the gear icon and select whether to save it as a look (saving the individual report to view in the future) or to a dashboard (adding the report as a tile on a larger dashboard with other reports).<img src="https://mintcdn.com/kibocommerce-59e68a4a/kGarQ_7QDUU5QUsX/img/save-report.png?fit=max&auto=format&n=kGarQ_7QDUU5QUsX&q=85&s=e5b088a4e44ea8164dfc864fa2b8ce43" alt="The expanded options menu of the Explore page with the Save options" width="575" height="403" data-path="img/save-report.png" />
9. If you click **Save as Look**, a modal will appear with several options. Enter a title and description for this custom report.
10. Select whether to save the report to your Personal (where only the creator of the report can access it) or Shared (where all Report Viewers across the organization can access the report and Report Editors can also modify the report) folder.<img src="https://mintcdn.com/kibocommerce-59e68a4a/kGarQ_7QDUU5QUsX/img/save-look.png?fit=max&auto=format&n=kGarQ_7QDUU5QUsX&q=85&s=210f62cdef525bcf0e828f2d8bc79305" alt="The Save Look modal " width="809" height="699" data-path="img/save-look.png" />

## Create From Scratch

Rather than base the new report off of an existing one, the Reporting Editor can also create and save their own reports from the data found in the explores.

1. In the folder navigation, go to **Shared** > **Kibo Standard Reports** > **Explores**.
2. Select the explore to base the report on.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-navigation.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=2d991610836f0f9e7e56b4a668817c77" alt="The navigation menu with a list of Explores" width="267" height="287" data-path="img/explore-navigation.png" />
3. From that screen, expand the gear icon at the top right and click **Explore From Here**.<img src="https://mintcdn.com/kibocommerce-59e68a4a/11fMEclnoleINoq4/img/explore-from-here-2.png?fit=max&auto=format&n=11fMEclnoleINoq4&q=85&s=b2a651256ddc73c070e86d805fc332c3" alt="Callout of the gear icon and Explore From Here button" width="595" height="844" data-path="img/explore-from-here-2.png" />
4. Customization options will be displayed. Select the dimensions and measures to include in the report from the menu on the left. Each selected dimension or measure will show up in the **Data** tab in the right.<img src="https://mintcdn.com/kibocommerce-59e68a4a/RFia3SXPeyM44geJ/img/report-customization.png?fit=max&auto=format&n=RFia3SXPeyM44geJ&q=85&s=e824466140f1566554929d3957ae57eb" alt="Customization options for what data to include in a custom report" width="1555" height="524" data-path="img/report-customization.png" />
5. The **Data** section displays the raw report results and includes features such as selecting sort order for columns, specifying the maximum rows to return, dragging and dropping columns to reorder them, and adding custom calculations. View pivots by hovering over a dimension and clicking **Pivot**.<img src="https://mintcdn.com/kibocommerce-59e68a4a/RFia3SXPeyM44geJ/img/report-customization-data.png?fit=max&auto=format&n=RFia3SXPeyM44geJ&q=85&s=ee9cec42edbd7ad1e3b246685cfc4f6a" alt="Example of data options selected for a custom report, also showing the Pivot and Filter buttons" width="1438" height="472" data-path="img/report-customization-data.png" />
6. Filters can be added the same way. Expand the **Filters** section and configure the values for filters there.<img src="https://mintcdn.com/kibocommerce-59e68a4a/RFia3SXPeyM44geJ/img/report-customization-filters.png?fit=max&auto=format&n=RFia3SXPeyM44geJ&q=85&s=3437ec87367efdd30a999fa18283d720" alt="The Filter options when creating a custom report" width="1528" height="421" data-path="img/report-customization-filters.png" />
7. Once all data has been selected and filters have been applied, expand the **Visualization** tab to see a graphical depiction of what the report would look like as a tile. Select different visualization types to analyze which works best for the data. For more control, use the gear icon in the top right to access more granular configurations.<img src="https://mintcdn.com/kibocommerce-59e68a4a/Es64Q0i6Wdv3qOS9/img/custom-report-visualization.png?fit=max&auto=format&n=Es64Q0i6Wdv3qOS9&q=85&s=9df856fb396363cd54cc54b37a63f715" alt="Example of the Visualization options, with a pie chart selected" width="1029" height="562" data-path="img/custom-report-visualization.png" />
8. Click the top-level gear icon to save the new report. It can be saved as an individual look or added to a dashboard, as well as directly downloaded or sent via email/SFTP/etc. A **Save & Schedule** option will save the report as a look and set up recurring delivery.

## View Custom Reports

The shared folder, where all Report Viewers in the organization can access the report and all Report Editors can modify the report, is located at **Shared** > **Custom Reports**.
