Creating Charts with the Dynamics CRM Online Chart Designer
November 2009 Service Update Article #3
In another article, I did a quick write-up and linked to a recorded tutorial on how to use the charts that come built-in to Dynamics CRM Online. Basically, they are available to end-users, who can use them to personalize their home page, with up to four charts across the new horizontal “Chart Pane”.
The only entities that arrive stocked with charts are:
- Accounts
- Activities
- Campaigns
- Cases
- Events
- Leads
-
Opportunities
For example, Account comes with three charts, providing graphical counts of your accounts across territories, territories and owners. The Case entity ships with fifteen (!), most of which show distributions of cases (using counts, again) across various attributes like origin, priority, type and so forth. Opportunities, on the other hand, are all about sales, and the ten charts built-in for that entity are almost all different cuts of forecasted (open) and historical (closed) sales.
I encourage you to explore these built-in charts and see what’s available, for a couple reasons:
- The charts provide a good guide for what kind of information is commonly tracked in Dynamics CRM, and more importantly, what kind of information your organization should be tracking. For example, if your Accounts by Territory and Accounts by Industry charts show you a single big bar labeled “Blank”, you might consider defining and using meaningful values for those two attributes!
- After you know what’s available, you’ll know what you need to create, which brings us to the topic of this article.
Creating Charts with the Chart Designer
You can add custom charts for either system entities or custom entities. Assuming you’ve got sufficient privileges (by default, contained only in the security roles “System Administrator” and “Customizer”), you add them using a new tool called the “Chart Designer”, which is available through the familiar entity customization UI:
- In the navigation area, click Settings, then click Customization.
- Click Customize Entities.
- Locate the entity to add a chart for, and double-click it to open it.
- Click Charts, then click New. The Chart Designer opens. Here’s a screen-shot of it on top of the slightly modified customization UI (for Contact, in this example)

The Chart Designer is a self-contained one-window application, which as you can see from the picture, requires you to specify the following properties to build your chart:
- Record Type View. Select from existing system views in the drop-down list. Every chart is based on a view, and the view does the data filtering work. When you create a new chart you may need to create a new view first, although you might be able to use one of the existing views.
- Chart Name is self-explanatory.
- Legend (Series). I’ll refer to this as the “Series”, but whatever you call it, it’s what provides the data for your chart: the height of a bar in a bar chart, or the percentage of the pie a piece takes up. If you select a text field you can only select “COUNT” as the “aggregate”. If you select a numeric field you’ve got a bunch of options (MAX, MIN, SUM, etc.)
-
Horizontal (Category). The Category represents the values across which the data will be distributed. So for a bar chart, the height of the bars will display the aggregated data, and you’ll have one bar per category. Two examples:
- If you want to see the number of accounts in each territory, make a chart based on the Active Accounts view, and select Account Name as the Series and Territory as the Category.
- If you want to see the total of account annual revenue just for your accounts, distributed across industries, select My Active Accounts as the view, Annual Revenue (Base) as the Series, and Territory as the Category.
Here are a few tips, tricks and gotchas, based on my admittedly limited experience with the tool:
- Views must be published before they can be selected (to base a chart on), and charts must be published before they can be selected (in the dashboard). Notice the Publish button in the customization UI.
- Within the Chart Designer, the “preview” that’s displayed is real data and it displays in real time. You can use this as a kind of a what-if visualization tool, seeing how your data are distributed across different attributes for the Category value, for example.
- It took me a while to figure out how the “Sales Funnel” chart type worked. I thought there was some behind the scenes magic dependent on having a staged workflow for opportunities, and that it only worked for opportunities, or something arcane like that. But if you want to figure out the “Sales Funnel”, try this:
- Open up the Opportunity entity’s customization UI, and click Charts.
-
Double-click the out of the box Sales Pipeline chart. Depending on … you may see an inherently uninteresting funnel with one data point, as I did the first time I tried it:

-
That’s because the out of the box version uses Pipeline Phase as the category attribute. If it doesn’t contain any data every category in the sales pipeline funnel goes into the “blank” category. So just change the category to something that contains data, and you can get a nice pipeline funnel. For example, my organization uses a different attribute to represent our sales pipeline: the system picklist, “Sales Stage” (attribute name “salesstagecode”). Here’s what the pipeline funnel looks like if all I do is change the Category to a field with data:

Apparently what the sales funnel chart type does is to “display values as progressively decreasing proportions” (from the online help). You can see in the screenshot that in this case it works as expected. I’ve experimented with different attributes for the category and got different results, however, such as the aggregates for the category values not appearing in “progressively decreasing proportions”. There are definitely some nuances I don’t understand about this chart type yet, so if you’ve got it nailed, please let me know!
Summary, What’s Missing
After a custom chart is created and published, it will be available for use by any user (with sufficient privileges) on their homepage dashboard. I haven’t yet figured out a way to create a chart and then make it available to all users, so the (apparent) fact that each user must go through the steps required to personalize their home page dashboard in order to consume these charts…well, it seems like a bit of a limitation. These must be exposed somehow, but like I said, I haven’t figured that one out yet, so if you have, please let me know!
So at least as far as I’ve been able to tell so far, custom charts can be created by a user with sufficient security privileges and then consumed by users as a personal configuration only. It would be nice if you could create a shared dashboard page that exposed the same charts to multiple users, but like I said…I haven’t figured that one out yet.
In the meantime, here’s something that’s better than nothing: if you add “/Home/Homepage/TTV_Home.aspx” immediately after the “dynamics.com” part of the URL you use to get to Dynamics CRM Online, at least you can get a nice personal dashboard that displays bigger charts without the baggage of the rest of the UI. For example, if I navigate to https://imginc.crm.dynamics.com/Home/Homepage/TTV_Home.aspx, here’s what I see:

Cheers –
Richard Knudson – richardk@imginc.com
new web site: www.IMGinc.net





















Brought to you by Richard Knudson and IMG.