Using custom reports, you can decide which metrics to track, how they're organized and what filters you use. You can choose which visualisations you'd like, compare metrics and apply even report-level filters to organize your datasets.
Creating a custom report
When it comes to creating a new custom report, there are two options:
Cloning a curated/existing report
Creating a new report from scratch.
Cloning a curated/existing report
A curated report is a report that is available out of the box in the web application. Curated reports are a list of the most popular or commonly used reports. You can clone a curated report with all its widgets and add modifications on top of it.
To access curated report, navigate to Analytics and click on the curated reports section:
Let us assume you would like to modify your Sales Dashboard to capture sales across your product categories. Here’s how you can do that.
Go to the curated reports section and click open the Sales Dashboard.
Click on the report name. This brings a dropdown menu.
Click Clone Report. This clones the report with all the widgets and you can customize it to create a new report.
Now, you want to modify the report to capture Product sales per Sales agent for the month. This can be accomplished by adding the ‘Product’ field as a group to the report.
Hover over the ‘Pipeline’ report and click on the expand button.
Add the ‘Product’ field to the GROUP BY section.
Click . This applies the segregation to your report and will split the report into sales per owner with individual products.
Creating a new custom report
Let us assume you wish to create a report to view Sales for each territory for a quarter.
Click the icon and select Analytics. This opens the reports page where you can find all existing reports.
Click the button. This opens a brand new blank report.
You can click on the "Untitled report" box to add a name to your report.
Once you create a new report, you will be able to add widgets to the report.
Here's how you can modify widgets:
Designing the layout of the report
A report consists of widgets. You can add charts and text widgets to a report and categorize them using pages. You can add style to a report's elements - background color, border, change font, etc.
How to create a new widget:
In the case of our example, we will have to create a widget. Here’s how you can create the widget.
Click the + Add widget icon and click New.
Since you are creating a chart, choose the Chart widget. Drag and drop the widget on the report builder. Hover over your widge and click on the expand button to edit the same.
Note: Additionally, you can access existing pre-built widgets from the "Gallery" and edit them to suit your needs.
To alter the name of your widget, click on the pencil icon under "Chart configuration".
Choose the metric for which the widget is being created. In our example, you can choose ‘Deals’ ( or Opportunities )
Create your widget by adding filters for your metrics and groups
Use the following logic to create the widget
Customize the elements and data labels of your widget
With the style option, you can customize the look & feel of your reports including titles, data labels, legends, axes, and more. Use data labels to read numbers on the chart. Customization options include font selection, font size, color, and style
Applying filters to a report
You can apply filters to all the widgets in a report. These filters can be basic (all conditions matching ANY or ALL) or advanced (multiple groups of conditions matching ANY or ALL). You can filter data using deal properties like status or deal value or industry.
Saving changes to a report
When modifying the filters for a widget or a report, click Apply for the changes to be reflected in the report/widget.
Once you apply your changes to a widget, you have the option to save the modifications to the widget, save the modifications as a new widget and add it to another report or the current one, or discard the changes. Similarly, when you modify a report, you have the option to save changes or discard them.
Presenting a report
The presentation mode for a report makes sure to remove all the distracting details - the navigation bar, the filters buttons, etc. - from the screen and give data the spotlight it deserves.