1 Reply Latest reply on Jan 30, 2012 10:23 AM by philmodjunk

    Pie Chart With Collection of Records



      Pie Chart With Collection of Records


      Hi All,


      I've never used the charts feature in Filemaker before (since it's a new feature and all), so I'm a wee bit stuck with this one.

      I want to make a pie chart that give me a display of how many deals in a found set were won / lost. The data currently is simply a feild that states either "won" or "lost".

      Currently Filemaker shows me a chart with one slice of the pie for each record, so I have slices all over the show, even though most of them are the same.

      How do I get Filemaker to collect up the records and work out a logical chart?

        • 1. Re: Pie Chart With Collection of Records

          First, you need a summary field that will count the records in your found set. With correct sorting, this field will report the number of "won" and "lost" records.

          Define a summary field in your table that "counts" another field in your table. Select a field that is never empty such as a serial ID field if you have one. We'll call this field, sCount for future reference here.

          Second, set up your pie chart and specify sCount as your "value data". Select your field with "won" or "lost" as your label data.

          Now be sure to specify the following two chart options:

          Use data from current found set
          Show data points from groups of records when sorted.

          You can put this chart in the layout body and specify a form view as you only need one chart for the entire found set.

          Enter browse mode and sort your records by the field with "won" or "lost" to group the data correctly and you should now get a pie chart with two "wedges" labled "won", "lost" with percentages for each.

          If you've set up summary reports with sub summary parts before, you may notice a distinct similarity between the wedges of your chart and sub summary layout parts--both only show the correct subrtotals or percentages if the found set of records is correctly grouped by sorting.