Skip to main content
All CollectionsReporting Engine
Reports — Creating Dashboards and Charts
Reports — Creating Dashboards and Charts

How to create charts and custom dashboards within Analytics › Reports and how to modify the report layout and utilize the actionable data

Updated over a week ago


Users can create their own customizable Dashboards — including charts of different types — based on the data from standard, pivot table, and advanced reports ⤵

Charts can be added to an individual report and also added to a Dashboard to create a consolidated view of different metrics for your business. Available chart types include Pie Charts, Lines (single and multi), Columns (single, stacked, multiple), Bars (single and stacked) as well as system types such as Scorecard.

Reports can be exported to xlxs/csv files or printed to pdf (if users have the rights to do so), Charts can be exported as png files or copied to the clipboard for easy pasting into a presentation or email and Dashboards can be printed to pdf.

Dashboard layouts can be edited and the charts resized to create just the right view.

Click on an element of your Dashboard to drill down to the underlying actionable data.

Before creating Dashboards you’ll need to know how to create Standard Table and Pivot Table reports. These are covered in this article "Management Reports — Creating a Standard Report or a Pivot Table Report".

Helpful Hints

  • Reports are based on the data that you and your team have already entered into Pipeliner.

  • Reports are dynamic which means that as you change the information in Pipeliner, the Report that contains that information is automatically updating with the latest information.

  • Every Pipeliner user with the right to use Reports can create their own Reports and share reports with others. However, a user can only see data they have rights to in any Report. For example, if a user only has the right to see their owned opportunities, they will not be able to see any other users’ opportunities even when viewing an “All Opportunities” report.

How to Create a new Dashboard

Click on the “Analytics” menu and then select “Reports”. Click on the “Create New” button and choose “Dashboard” ⤵

Give your new Dashboard a name. You can also add a description so that any user accessing the dashboard will know what it intended to display. Finally, select a folder for your dashboard to live in and click on “Create” ⤵

Your new empty Dashboard will be created, ready for you to add charts and build your custom layout ⤵

Click on the “Add” button to start adding content ⤵

You can add a...

  • New Report — create a new report, enable a chart within the new report and add the chart to the Dashboard

  • New Report from Profile — create a new report based on an existing saved profile, enable a chart within the new report and add the chart to the Dashboard

  • Existing Report — select from existing reports and add the chart to the Dashboard or add the report data and create the chart in the Dashboard

  • Custom Chart — there are a small number of system charts — for Opportunities, this includes a chart that displays conversion rates from step to step

How to Create a New Report with a Chart and add the Chart to a Dashboard

Click on “Add › New Report” and then give your new report a name, add a description if you choose to, select a Folder for the report to be stored in, and then select the Record Type and which type of report table you are creating. Finally, click on “Create” ⤵

The new report will be added to the Dashboard as the first chart type which is Scorecard ⤵

NOTE: When you’re using a Scorecard chart type, note that you can also enable comparison by switching on “Show comparison”.

Pick the date to base your comparison on and then the Period to compare to ⤵

Sum and Average Values on Charts

When hovering over a graph, you can see the "Sum" (and also Average, if using the Average line). This is a really quick and easy way of viewing the total opportunity value for all owners when using a stacked column, for example ⤵

Percentages in Charts

When using pie, column, multi-column or bar charts, users can now select “Show percentages” (as well as, or instead of, “Show numeric values”) ⤵

Comparison of Values in Line Charts + Bar Charts

When using a Column or Line Chart, you can enable “Show Comparison” and choose to see just the "Previous" period or select custom options to compare your current results against. This is an easy way to visualise current performance vs previous periods ⤵

To Current Date Comparison

If checked, the end date of the comparison period is changed to the current day. This option is also available for time periods on the X-axis for line, column and bar charts ⤵

Running Total

Running total provides a cumulative sum, or count, of a particular measure over a specific period of time which allows users to easily track and visualize the total sales over time, identify trends, peaks etc.

There are two new functions

  • Sum (Running total) -> summarizing number or currency fields

  • Count (Running total) -> summarizing the total records in the chart

Running total is available on all graphs except Scorecard.

This function can be combined with the “To Current Date Comparison” to compare sales to date with the same period in a previous year.

Grouping in charts where fields contain multiple values

If you include a multi-select, lookup, editors, or watcher field as an X or Y value in a chart, by default, the values are grouped in combinations as shown below ⤵

You can change the grouping mode to "Group by values" to change to each instance of single values instead. This does, of course, mean that a single record - Opportunity, for example - may be counted more than once if it contains multiple values in the selected field - e.g. if it has multiple Editors assigned ⤵

Using Segments in the Y axis for Multi Line, Stacked Column, Multi-column and Stacked Bar Charts

Multi Line, Stacked Column, Multi-column and Stacked Bar charts support different types of field in the Segment of the Y axis including numbers, text fields, dropdowns and date fields ⤵

Whichever type of chart you choose, you now need to edit the "View Options" to start customising the report and chart.

In the “Chart” tab, change to the type of chart that you want to include in the Dashboard and Report.

In our example, we’re going to choose a Column chart with the Number of Opportunities in the Y-axis and the Owner in the X-axis

Click on the “Table” tab and select the columns you do (and remove those you do not) want to see when you click to view the underlying data for the report ⤵

Next click on the “Role” tab and make sure that all ticks are checked to ensure that the report will include all data not just your owned records ⤵

Click on the “Filter” tab to enable filtering and then enter your filter criteria in the Preset or Custom tabs.

In our example, we need a custom Filter to display only Opportunities where the Opportunity Created Date is in the current year

Add your target values and period under the “Target” tab for any target-based charts. Make sure you select “All Opportunities” to include all values in your target calculations.

NOTE: Remember to “Save” your layout whenever you see “Modified” in the Dashboard Settings

Clicking on “Open” will jump you through to the underlying report where you’ll see both the Chart and the Table that you selected options for. Click on “Back to Dashboard” to return to your Dashboard Layout ⤵

Properties” allows you to change the Name, Description or Folder for the report, “Share” gives you the option of making it “public” or sharing with specific colleagues and you can also select “Copy” or “Remove” from the additional options ⤵

If you select “Add › New Report from Profile”, you’ll be able to choose from a saved profile which means that your role and filter options will already be set for your report. Otherwise, the steps are the same as those described for “Add › New Report” ⤵

How to add an Existing Report to a Dashboard

Click on “Add › Existing Report” and you’ll then be prompted to browse through your report folders to find the report. Once you’ve found it, click on “Add” ⤵

If your report already contains a Chart, it will be added to your Dashboard Layout. If not, you’ll now need to set up your Chart options by clicking on the “Options” icon in the top right of the Chart space and selecting “Edit” ⤵

Switch on the "Chart" first of all ⤵

Then decide on the type of chart you want to use and the "X" and "Y" values ⤵

Check out the “Role”, “Filter” and “Target” tabs to make sure that the correct options are selected, and remember to keep saving your Layout.

Adding Charts to a Dashboard from a Report

When you’re working on a report, you can add a chart to your report using the “Chart” tab just as you do from a Dashboard ⤵

Once you are happy with your chart, you can add it directly to a Dashboard by clicking on the “Add to Dashboard” button ⤵

Search for the Dashboard you want to add the chart to and then click on “Add” ⤵

You’ll be able to click straight through to your Dashboard from the prompt, using the “Open Dashboard” option or you can carry on working on your report and review your Dashboard later ⤵

Copying a chart to add to your Dashboard

You can easily copy an existing report and chart and amend it.

This example is a copy of the “2021 Opportunities by Owner” chart. The chart type was then changed to Stacked Column and Fitness was added as the Segment ⤵

Printing a Dashboard

Click on the “Print” button to print your Dashboard to a pdf file. Choose your preferred PDF Settings including Orientation and Scale ⤵

The resulting pdf will be downloaded by your browser and can be accessed from the Downloads folder.

Sending a PDF of your Dashboard by email

Click on “Send” to create a one-off email with your Dashboard attached as a pdf ⤵

Or choose the “Schedule” button to send regular updated Dashboard pdfs to selected email addresses ⤵

For more information on Scheduling, click here.

Dashboard Settings

The Settings button allows you to “Save” your Dashboard and also gives you a list of all the charts included. You can also filter the entire dashboard based on the same users or sales units.

NOTE: This is a fantastic time-saver if you’re creating a general Dashboard looking at, say Opportunities, but you want to be able to share with different users or teams (units). This way you can copy the whole Dashboard and apply the filter at the whole Dashboard level rather than having to change the filter within each chart/report! ⤵

Sharing your Dashboard

By default, like everything else in Pipeliner, your new Dashboard is “Private” and is visible only to you.

To share a dashboard, click the "Settings" button in the upper right of the dashboard. Select the drop-down next to private and select the "Custom" to share it with specific Pipeliner users on your team, or "Public "to give all Pipeliner users the rights to see or edit the report.

Add Users or Sales Units as "Additional Editors" to give colleagues the right to modify the report (but not change Ownership or Delete) or as "Additional Watchers" to give read-only rights to see the report ⤵

When adding charts to a shared Dashboard, it can be easy to forget that you also have to share the report that the chart represents or other users will not be able to see that content on the Dashboard. We’ve added a warning message when there are discrepancies between the sharing options selected for the Dashboard and the reports used in it to remind you to set the sharing to the same options ⤵

Editing a Dashboard Layout

To change the layout of your Dashboard, click on “Edit Layout” ⤵

You’ll then be able to resize each chart ⤵

And move them around to get the layout you want ⤵

Don’t forget to “Save Layout” when you’re finished ⤵

Drilldown into Report Data from your Dashboard/Chart

Click on any element of a chart — either from a Dashboard or a Chart within a Reportto drill down to the underlying data

This is actionable data … "Select any" (or "All") records to access a full menu of actions to apply to the selected records ⤵

To work on the records, click on the “Open All in Detail” button. This will open the Detail of the first record with the left-hand pane already open to allow easy navigation from one to another so each record can be easily updated ⤵

Related Articles/Next Steps

Did this answer your question?