web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / crm 2013 "Compari...
Microsoft Dynamics CRM (Archived)

crm 2013 "Comparison charts do not support more than one measure collection."

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have created one chart for salesorder for displaying total amount and total count group by account region and

salesorder statecode.below is the xml for that

Capture_5F00_3_5F00_060115.PNG.

If i import it it is showing me the below error

Comparison chart, which are charts with subcategories, cannot have only one measure collection.

But, if i remove one group by new_region or statecode then it will be imported and no error.

the same is for if i remove the attribute alias then also it will not give me error.

I have a requirement that i need to group by "new_region" of account and by order statecode also and i also have to dispaly the sum of total amount and total number also.

Any idea.

Please suggest.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    Rajkumar Rajaraman on at

    Hi kandarp,

    Is this what you are looking for?:

    crmchartguy.wordpress.com/.../aggregate-total-on-top-of-stacked-column-charts-or-bar-charts-in-ms-crm-2011

    Hope this helps.

    Regards,

    R.Rajkumar

  • Community Member Profile Picture
    Community Member on at

    But in this link there is only one group by and single entity there and no link entity.

    My case is different from it.

  • Rajkumar Rajaraman Profile Picture
    Rajkumar Rajaraman on at

    Hi Kandarp,

    You can try this link:

    missdynamicscrm.blogspot.in/.../show-field-as-group-by-or-axis-x-from-another-entity-crm-2011-2013-charts.html

    Hope this helps.

    Regards,

    R.Rajkumar

  • Rajkumar Rajaraman Profile Picture
    Rajkumar Rajaraman on at

    Try this also:

    crmchartguy.wordpress.com/.../related-entities

    nishantrana.me/.../sorting-on-link-entitys-attribute-in-fetch-xml-crm-2011

    Regards,

    R.Rajkumar

  • Community Member Profile Picture
    Community Member on at

    Thanks for reply Rajkumar.

    But, this is not what i want in my case.

    Thanks for your response.

  • Verified answer
    mscrmba Profile Picture
    mscrmba on at

    Hi Kandarp,

    *  OOTB CRM supports either 2 horizontal (and 1 vertical) or 2 vertical (and 1 horizontal) groupings.  Not 2 of each at the same time - which may be the cause of your error message.

    *  It may be possible to present a chart using groupings and/or additional sequences rather than sub-categories.  Or possibly to add e.g. the counts in as a separate series of numbers.

    crmchartguy.wordpress.com/.../multiple-series

    If that isn't getting you there:

    *  Suggest you have a good hunt on crmchartguy's site - and send him a query if there is nothing like what you want on his blog already.  He really is an expert, and very helpful.

    If it's not possible then:

    The simplest fall-back alternative I can see is to have 2 stacked column charts with horizontal axes of Account Region and Statecode - one chart each for $ Amounts and Counts.  

  • Community Member Profile Picture
    Community Member on at

    Thanks for Response.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans