3 Replies Latest reply on Dec 12, 2015 1:27 PM by Mike_Mitchell

    multiple charts


      Is it possible to have two different pie charts: one to show the percentage of Medium (i.e. photography/ drawing/ painting) and then another pie chart to show the % of the work owned by an artist? Do you have to have two layouts?



        • 1. Re: multiple charts

          A chart is an object, not a layout. You can have as many as you like (given space constraints) on any given layout.

          • 2. Re: multiple charts

            The data in the second chart is not summarized properly though and i did the sort by artist and secondarily by medium. How could I show these 2 pie charts and have both summarized properly?Screen Shot 2015-12-12 at 4.13.33 PM.png

            • 3. Re: multiple charts

              The charts are doing exactly what you told them to do. Since all records under artist are sorted together, the summaries work. However, you have multiple instances of each medium, therefore, you get multiple pie slices.


              To fix it, you can do a couple of things:


              1) Use a self-joining relationship and summarize medium based on that.

              2) Assemble a list of media in the current found set (probably using a ListOf summary field). Then, loop over it and use GetSummary ( ) to assemble a corresponding list of values to use for your data series.


              But basically, you can't use the found set directly on a secondary sort. The summaries split based on the sort order.