This article covers the following topics:
Users can create their own customizable Dashboards — including charts of different types — based on the data from standard, pivot 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.
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".
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 rights 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 rights 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 the 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 and add to 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 ⤵
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 ⤵
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. Click to Share your Dashboard with every other user by selecting “Public” or with specific users by choosing “Custom” ⤵
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 ⤵