Skip to main content

Create a Dashboard and Add a Waterfall Chart

Let Your Data Flow

Within your dataset, your opportunities are categorized by the sales-cycle stage they're in. Opportunities start out as prospects, or qualified leads, that have been gathered from various sources. In our scenario, your task is to provide an easy-to-understand snapshot of where these opportunities are in the current fiscal year.

If you’re not still there, locate the Dataset tab for your ProductPipelineUSA dataset. Click the Explore button in the upper right to begin exploring it in a lens.

Massage the Data

The default exploration brings up a bar chart with a count of rows, but we've already decided that a waterfall chart would be a good visualization for opportunity stages. Before we get to the waterfall, we first have to query the dataset to get exactly the data we want to display, then we'll clip the lens to the dashboard designer.

  1. Click the Bars plus button, then choose Stage to group the rows by stage. Grouping by stage in a lens
  2. Click Count of Rows to change the current measure by setting the Bar Length field. Choose Sum for the aggregate function, and then choose Pipeline Amount as the field for the Bar Length. A bar chart displaying sum of pipeline by stage
  3. Click Clip to dashboard designer to clip the lens (or the exploration with the bar chart) to the dashboard designer.
  4. In the Query Label field, type Stage_1 and click Clip to Designer. As soon as you clip the lens, the dashboard designer opens with a query in the right-hand panel that represents the lens. The query should have the name Stage_1. Step clipped to dashboard designer
  5. Drag the Stage_1 step from the right sidebar onto the canvas to recreate the bar chart.
  6. Adjust size of the bar chart—drag the sizing handle on the right side to make the chart fill the entire width of the canvas. Pipeline stages bar chart in dashboard designer
  7. With the bar chart selected, click Chart Type and choose the Waterfall chart type. Pipeline stages waterfall chart in dashboard designer
  8. Click out of the Chart Type area to hide the chart types. And click the chart in the canvas.
  9. In the Title field, enter Current Product Pipeline by StagePipeline stages waterfall chart title in dashboard designer
  10. Click Save to save the dashboard.
  11. Give your dashboard the title of Product Pipeline USA, and then click Save.

Remember that the original dataset contained all opportunities for this fiscal year, and in our exploration we didn't filter by date. Because of that, this waterfall chart shows where all of the current fiscal year's opportunities are by stage, including those that have closed.

What insights can we gain from this waterfall chart? For one thing, it looks like the vast majority of opportunities are still in the early stages of the pipeline. Another insight: The win rate for opportunities that are closed is quite high. Sounds like your company needs to move those opportunities along!

What's next? You'll bring your opportunities into focus with a map chart.

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities