Follow Us:
This entry is part of our Feature Review Series. These short, to the point blogs strive to provide a quick snapshot of information to a user looking for a quick overview of a feature, how it's managed or configured, some insight into how a business / organization would use it, and provide links to resources or tutorials for a deeper dive.
Charts are graphical representations of data. As you likely know, each table in Dynamics has hundreds, perhaps thousands, of rows of data. While you can sort, filter, and organize the data in logical ways, it doesn't take long for a data set to become overwhelming to summarize, let alone understand.
Enters: charts.
A chart can quickly take a massive amount of information and present it in a way that someone can quickly comprehend what's happening in the data.
For example, a chart might display customers by time zone.—this helps the viewer quickly decipher when it's appropriate to call the customer. Or, a quick summary of active cases by "Case Type," which might help a routing agent know where to pass the cases as they are triaged.
Below is a sample chart provided in a trial org of D365's Sales Hub:
To view a chart, navigate to any table. You'll find the "Show Chart" icon in the ribbon of the table, as shown below. Tapping this will open the chart pane.
Users can see "System" charts and "Personal" charts.
Charts are differentiated this way when you open the chart pane, as illustrated here:
To create a new chart, navigate to a table and open the chart pane. Then, click the ellipses to the right of the chart title to expose the menu and click "+ New."
At the time of writing, tapping new will open a new browser tab with the chart builder.
On it, you'll find a variety of options. We've highlighted the basics below the image. You can learn more here.
You'll find "Top X Rule" and "Bottom X Rule" icons on the far right. These allow you to embed filtering of the results. As an example, you might want to display only the top 5 Opportunities.
The preview pane provides a sample of the dataset. Keep in mind that the chart will align itself with the view you have open, so this is truly only a sample of what the chart will look like for illustrative purposes.
The Legend and Axis area allow you to select the fields. Legend represents what is being counted, and the axis defines how that data is being segmented. As you see below, we're looking for Accounts (counting the account name) by the number of Open Deals they have, showing us that we have five Accounts with 0 open deals, and five Accounts with one open deal.
When viewing a published chart, you can perform a drill-down on records making up the chart. This convenient feature allows the user to dive into the data to analyze further what they are seeing.
Below there are two screenshots. The first has the My Active Accounts view loaded and displays the Accounts by Address 1: City chart. The second is showing the same view AFTER I've clicked the REDMOND column. The data set has reset itself to show me the three Accounts that make up that data.
First screenshot:
Second screenshot:
Note that I can "Drill Down By" - this allows me to select a new chart type and attribute to examine the data by. For example, I could then add in Open Deals to see which Accounts in Redmond have open deals (not shown).
There you have it! A crash course in the extremely valuable Charts feature. We encourage you to dive into your Sandbox or open up a trial environment and play around with charts. Questions on how Charts could impact your team and enhance your understanding of your data? Contact C5 today!
The complementary paper includes over 12 years of research, recent survey results, and CRM turnaround success stories.
Request Download
This 60-second assessment is designed to evaluate your organization's collaboration readiness.
Learn how you rank compared to organizations typically in years 1 to 5 of implementation - and which areas to focus on to improve.
This is a sandbox solution which can be activated per site collection to allow you to easily collect feedback from users into a custom Feedback list.
Whether you are upgrading to SharePoint Online, 2010, 2013 or the latest 2016, this checklist contains everything you need to know for a successful transition.