Skip to main content

Add a Map Chart

A Map Is Worth a Thousand Words

Using a waterfall chart, you've established that there are many opportunities out there just waiting to be moved along the pipeline to closing. But where exactly are those opportunities located? Knowing this will help your company decide where to focus its efforts and expend resources.

For this, you'd like a visualization that neatly ties together the number of opportunities with their location. Your company's sales and distribution network runs at the state level, so a map of the United States would be a perfect way to communicate location and potential sales. You'll be able to do this using the pipeline dataset and a map chart. Make sure the Product Pipeline USA dashboard is open before you start.

  1. In the header navigation, click Analytics Studio.
  2. In the Browse tab, filter by Datasets and further refine the search results by selecting Created By Me.
  3. From the search results, click the ProductPipelineUSA dataset to create a new lens. (Be sure to click the dataset and not the dashboard.)
  4. Click the Bars plus button, then choose State to group the rows by state.
  5. Click Count of Rows, choose Sum for the aggregate function, and then choose Pipeline Amount as the field for the Bar Length. Product pipeline grouped by state
  6. Click Clip to dashboard designer to clip the lens to the dashboard designer. Name the new step State_1.
  7. This time, you'll have to go to the dashboard designer to see the new step in the right-hand panel. Just click the Product Pipeline USA tab.
  8. Drag the waterfall chart down to make room for the map chart, then click outside the chart to reveal the steps again. State step in dashboard designer
  9. Drag the step called State_1 from the right sidebar onto the canvas to recreate the bar chart.
  10. 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.
  11. With the bar chart selected, choose the Map chart from Chart TypeWorld map chart in dashboard designer In our case, the default map isn't the one we want—we'll change that.
  12. Click out of the Chart Type area to hide the chart types.
  13. Scroll down and click the Map section to expand the map options.
  14. In the Map Type list, choose US StatesUnited States map chart in dashboard designer
  15. Scroll back to the top of the Widget section and in the Title field enter Geographic Distribution of OpportunitiesUnited States map chart with title in dashboard designer
  16. Click Save and then click Save to save the dashboard.

You've now got a dashboard with 2 separate charts. The newest one, the map chart, tells you that most of your opportunities are in Illinois and Texas, followed by California and Florida. This can help answer some questions, such as where your company should be adding resources. It might also cause you to ask some questions you didn't know you had, such as why there aren't more opportunities on the East Coast.

We're nearing the end of our work. All we have left is to create a visual comparison of the different products by opportunity values.

Continue a aprender de graça!
Inscreva-se em uma conta para continuar.
O que você ganha com isso?
  • Receba recomendações personalizadas para suas metas de carreira
  • Pratique suas habilidades com desafios práticos e testes
  • Monitore e compartilhe seu progresso com os empregadores
  • Conecte-se a orientação e oportunidades de carreira