All things Pie Chart in Dynamics CRM

Somehow I have managed not to write about the Pie Chart in Microsoft Dynamics CRM. What you can do with the pie chart is fairly limited since only one series is supported. However, there are a number of custom properties we can use to tweak the appearance of the pie chart. Custom properties can be …

Design options for bar charts and Top X bar charts

Here's a couple of design options to improve bar charts, fix some pet peeves of mine, or simply change things up a little. Those pet peeves are truncated labels and always putting the top record on the bottom. Fortunately, both of those can be fixed as seen below. I've also positioned the labels on the …

Groupby Business Unit – even when not present (i.e. Activities/Opportunities)

In setups where both Users and Teams own records, it can sometimes be useful to group data by the owning Business Unit, rather than by the Users or Teams individually. Most entities allow you to add an "Owning Business Unit" column in Advanced Find to take care of that, but some do not. Most notably the …

Groupby on a related entity’s related entity

Are we focusing on the right Accounts and Opportunities? A common question in sales departments. Accounts are often classified in some kind of A, B, C categorization based on their potential value etc. Ideally, that means you sales activity should primarily be related to A accounts and some B accounts. However, a common setup in CRM, is to set …