Column Chart Showing Total Sales by Store Location

Click Add Chart.

Select the sample_supplies.sales data source.

In the Select Data Source modal that appears:

1. Click the Project tab.

2. Click the name of the deployment that contains the sample data source.

3. Click the sample_supplies database. The database's data sources appear.

2. Click Select on the sales data source.

Select the Chart Type

1. In the Chart Type dropdown, select Column.

2. Click Stacked below the dropdown.

Add the desired fields to the proper encoding channels.

1. Drag the storeLocation property from the Fields section of the Chart Builder view to the X Axis encoding channel. This tells MongoDB Charts to create a column for each storeLocation value in the dataset.

2. In the Fields section click the items field to expand the items object and view its properties.

   Note

   MongoDB Charts infers the data type of each field and provides symbols to easily determine these data types when building your chart. For example, the calendar icon next to the saleDate field signifies that this field is a timestamp. These symbols can help ensure your chart renders as expected by using proper data types for each encoding channel.

3. Drag the items.price field to the Y Axis encoding channel. The Y Axis encoding channel determines which field to use for the chart's aggregation.

   Example

   Aggregation

   Aggregation processes data records using a wide variety of methods and returns computed results which may not be available in the original dataset. Because we are interested in the total revenue from each store, we use the items.price field here and will use an aggregation operator which will allow us to add the items.price fields together.

4. In the Array Reductions dropdown, select Unwind array.

   Example

   Unwind array

   Array reductions dictate how to process an array so its elements can be visualized. The unwind array option creates a new document for each element in the array, so each item's price is added to the total for that store.

   For more information on unwinding arrays, refer to the unwind aggregation documentation.

5. In the Aggregate dropdown, select sum.

   Example

   Sum

   This option adds the prices of all items per store together to display the chart. For more information on the $sum aggregation command, refer to the sum aggregation documentation.

Your chart should now look something like this:

Notice that the stores generating the most revenue are the Denver and Seattle locations.

Title your chart.

1. Hover over your chart title above the center of the chart and click the pencil icon.

2. Copy the following into the chart title input:

   Total Sales ($) by Store Location

3. Click the check mark to save your title.

Click Save and Close at the top right of the chart builder view.

You will be navigated back to your Super Store Supply Sales dashboard and it should look something like this: