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

    multiple charts

    FeldyNYC

      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?

       

      Thanks.

        • 1. Re: multiple charts
          Mike_Mitchell

          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
            FeldyNYC

            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
              Mike_Mitchell

              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.