Charting on Activity Parties in MS Dynamics CRM

The Activity Party entity surfaced a little in the MS CRM blogosphere late last year. First Jukkan wrote this excellent piece “Your Interaction Network in Dynamics CRM” And then Joel Lindstrom and George Doubinski talked a little about the challenges of reporting on the activity parties in episode 14 of the CRM Audio podcast called … Continue reading Charting on Activity Parties in MS Dynamics CRM

Bubble Charts in Dynamics CRM

I usually stick to the standard chart types in my blog posts, even though Dynamics CRM supports many other types such as radar, polar, error bar and bubble charts. So it is time to venture out a little bit. In this post I will work with the bubble chart and show how to build one … Continue reading Bubble Charts in Dynamics CRM

Compare This Year to Last Year with a Dynamics CRM chart

Comparing sales performance this period vs. the same period last year is a fairly standard metric. However, to create a chart that compares the period this year, with last years in the same date range can be tricky. For example, today is June 21st. I want to see my actual sales for this year to … Continue reading Compare This Year to Last Year with a Dynamics CRM chart

N:N Relationship Charts in MS Dynamics CRM

N:N Relationships, or Many-to-Many Relationships, can be a little tricky to get information out of. As an example competitors out-of-the-box have an N:N relationship with opportunities. Let's say we wanted to look at a list of competitors and see how many active opportunities they are currently engaged in. With the chart editor and views, the … Continue reading N:N Relationship Charts in MS Dynamics CRM

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 … Continue reading Groupby Business Unit – even when not present (i.e. Activities/Opportunities)

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 … Continue reading Groupby on a related entity’s related entity