Build Simple Charts – Client Demographics (SharePoint)

Demographics Column Chart

Our first chart will be very simple to create - it will be a column chart which represent average revenue from a client in each Age Group.
As usually, we add Dashboard Designer Web Part to the page and open its configuration. In Data Source, we select our list and expand amount of Rows:

One extra thing that we will configure is the CAML Query, since we want results ordered by Age. Simply replace ID with Age in OrderBy tag:

Click Process, make sure there are no errors and let's move to Dashboard section:

Here we select Column Chart Type. We can give Name to our series, but since we have only one, this is optional.
For Category, I select "field" - "Age Group", and for Value, I select "avg" - "Revenue" to get the average revenue.

We can also go to Style tab, expand Value axis and set Label format: ${0}

Now, I click Preview and get the following Chart:

One done, two to go! Next up is a bar chart.

Demographics Bar Chart

We have information about gender and country of living of our customers, so let's utilize it. We add another Dashboard Designer Webpart, configure Data Source SharePoint List the same way, but this time we can leave the CAML Query alone.

Instead we need to go to Aggregation tab and select Group by: "Gender":

No extra fields required, just click Process. Now, we move to Dashboard section Chart tab:

A few things here:

1. Select Bar Chart Type
2. Check Display each group as a separate series
3. In Category, select "field" - "Country"
4. In Value, select "sum" - "Revenue"

We can also go to Style tab, expand Value axis and set Label format: ${0}

This will add a dollar sign to revenue, though this is fully optional. Click Preview to get this result:

Two charts! We are on a roll! Scatter chart coming next.

Demographics Scatter Chart

Finally, we can get an even better understanding on amount of Revenue brought by each client and overall stats with scatter chart which allows us to visualize spending habits of every single client. Let's add another Dashboard Designer Web Part to the page and go to configuration.

Data Source configuration is similar to two previous ones, but here we don't need to neither edit the CAML query or use Aggregation.
Simply select the list, expand amount of Rows and that's it. Don't forget to Process the data!

Now we move to Dashboard section Chart tab:

Once again, we follow these steps:

1. Select Scatter Chart Type
2. In X-Axis, select "field" - "Age"
3. In Y-Axis, select "field" - "Revenue"

We also need to tweak a couple of things in Style tab:
In order to make Age more readable, let's open X-Axis and set Label Format: {0} y.o.
We can also remove empty section from 0 to 15 years, since there are no customers of this age, by setting Boundaries(Min): 15
Expand Y-Axis and set Label format: ${0} (optional)

Finally, click Preview to get this result:

All charts are built! Hurray!