Explore recipe: Open pipeline by source

Zendesk is removing the Sell datasets and prebuilt dashboard from Explore on January 16, 2024. For more information, see Announcing the removal of Sell datasets and dashboards in Explore.

Note: Sell customers who also have a Suite Professional plan or higher may also create this report.

In this Explore recipe, you’ll learn how to create a report showing you the value of all of your upcoming deals in your sales pipeline, separated by their source.

This article contains the following topics:

• What you’ll need
• Creating the report

What you’ll need

Skill level: Intermediate

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving agents access to Explore)
• Sales data in Zendesk Sell

Creating the report

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Sell > Sell - Sales, then click Start report. The report builder opens.
4. In the Metrics panel, click Add.
5. From the list, select Deal value, and then click Apply.
6. In the Columns panel, click Add.
7. From the list, select Deal source ID, and then click Apply.
8. To change the report to a pie chart, click Visualization type () and select Pie.
9. To filter the report to just this year, click Add next to Filters (to the right of the Metrics panel), select Time - Deal created - Date and set it to the current year. For help with filtering, see Working with report filters.
10. To filter out deals with no recorded source, click the Deal source ID attribute on the left, click the Excluded tab, select NULL, and click Apply.

Tip: You can format the Deal value metric to include currency symbols and decimal places. Go to Chart configuration () and select Display format. Next to SUM(Deal value), select $, €, Finance, or Custom, depending on how you want to format the values next to each pie segment.

Optionally, you can use the drill in interaction to allow report viewers to dig into more details about the specific deals for each source.

To enable drill in

1. Go to Chart configuration () and select Drill in > Enable drill in.
2. In the Select attributes field, select the information that you want report viewers to be able to see when they click a segment in the chart. For example, you might choose Deal source ID, Deal name, Deal owner, and Time - Deal estimated close date - Date.