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.
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 Analytics 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.
Click the ‘Pipeline’ report.
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 and select iconReports. This opens the reports page where you can find all existing reports.
Click the button. This presents you with a dialog box where you can give your report a name.
Add a name to the report and set visibility of the report.– choose between Me and Everyone.
Click . This creates a new 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.
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.
Click ‘Add Chart’. This brings up the New Widget dialog box.
Give your widget a name. Name the widget suitably. In our example, you can name the widget ‘Deals by Territory’
Choose the module for which the widget is being created. In our example, you can choose ‘Deals’
Click Next. This takes you to the widget builder.
Create your widget by adding 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.