How to Create a Column Chart of Deals by Country

Creating a column chart is a powerful way to visualize deal distribution across various countries. This visualization can provide key insights into regional performance and help identify trends in deal activity, enabling data-driven decisions for your strategic planning. Follow the steps below to build a column chart that displays the total number of deals by country.

Visualization Example:

Steps:

Select "Pipeline Deals" from the Explore menu.
In the Field Picker section on the left-hand side, expand the Deal field. From the available options, select both Country and Count to track the number of deals per country.



Click the Run button located in the top-right corner to generate your results.
Once the data is generated, navigate to the Visualization pane on the right. Select Column Chart as your desired visualization type to represent the data.
To ensure accurate data representation, apply a filter to exclude null values from the Country field. This will help clean up the chart and display only relevant data points.



Once complete, your column chart will display the number of deals segmented by country, providing a clear overview of your organization's geographic deal activity.

Updated on: 11/09/2024