Add a Map Chart
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.
- In the header navigation, click Analytics Studio.
- In the navigation bar below that, click Datasets, then click the ProductPipelineUSA dataset to create a new lens.
Click the Bars plus button, then choose
State to group the rows by
- Click to clip the lens to the dashboard designer. Name the new step State_1.
- This time, you'll have to go to the dashboard designer to see the new step in the right-hand panel. Just click the tile named Product Pipeline USA.
Drag the waterfall chart down to make room for the map chart,
then click outside the chart to reveal the steps
- Drag the step called State_1 from the right sidebar onto the canvas to recreate the bar chart.
- 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.
With the bar chart selected, choose the
Map chart from
In our case, the default map isn't the one we want—we'll change that.
- Click out of the Chart Type area to hide the chart types.
- Scroll down and click the Map section to expand the map options.
In Map Type, choose US
- Scroll back to the top of the Widget section and in Title enter Geographic Distribution of Opportunities.
- Click 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.