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).
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.