locked
Chart grouping RRS feed

  • Question

  • Has anyone tried to do 3 groupbys? I was getting an error when i tried it.

    What i want to do is:

    Show all status (Open/Won/Lost/...) for the current Fiscal Quarter and Year.

    Thanks.

    Tuesday, April 24, 2012 7:58 PM

All replies

  • Hi,

    Where are you trying to do this group by. Can you please paste 2 screenshots. One of the actual group by you are doing so that we know exactly how you are doing. The other screen shot of the error you are getting, as we can get a clue of the error message.


    Ashish Mahajan, CRM Developer, CSG (Melbourne)
    My Personal Website: http://www.ashishmahajan.com
    My Blogs: http://ashishmahajancrm.blogspot.com.au and http://ashishmahajancrm.wordpress.com
    My Youtube Channel: http://www.youtube.com/user/ashishmahajanmscrm

    My Linkedin: View Ashish Mahajan's profile on LinkedIn
    My Twitter: https://twitter.com/#!/ashishmahajan74

    Wednesday, April 25, 2012 2:46 AM
  •       <fetchcollection>
            <fetch mapping="logical" aggregate="true">
              <entity name="quote">
                <attribute alias="aggregate_column" name="name" aggregate="count" />
                <attribute groupby="true" alias="groupby_column1" name="createdon" dategrouping="year" />
    			<attribute groupby="true" alias="groupby_column2" name="new_fiscalperiodmonttext" /> 
    			<attribute groupby="true" alias="groupby_column3" name="statuscode" />
    			<order alias="groupby_column1" descending="false" />
              </entity>
            </fetch>
          </fetchcollection>
    

    where new_fiscalperiodmonttext contains the month name of createdon.

    The error was:

    Invalid data description
    The <datadescription> element cannot contain more than two Group By clauses.

    Thanks.

    Wednesday, April 25, 2012 11:56 AM