Using FetchXML to combine data in a chart
The charts created and displayed in Dynamics CRM use the
FetchXML syntax to query the underlying Dynamics CRM data source. Users can create comparison charts using the designer, but the comparisons are only based on one entity type. This recipe will create an Account SLA chart that shows how to manipulate the FetchXML query to pull and compare data from two different entities (Account and Case entities).
Getting ready
This recipe assumes that the reader has reviewed the earlier recipes and is familiar with how to export and import a chart from Dynamics CRM. This recipe will require you to add custom fields to the Account entity and make sure there are some active Case records related to active Accounts. ...
Get Microsoft Dynamics CRM 2011: Dashboards Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
