3 Replies Latest reply on Jul 5, 2011 11:21 AM by philmodjunk

    Pie Charts: Thought this would an easy one But ...

    JoelCornette

      Title

      Pie Charts: Thought this would an easy one But ...

      Post

      Trying to convert a previous database to FM Pro 11, reconstructing pie charts -- nothing seems to work. Read the forum here, but still getting the same results ...

      Basics:  I have a database with a field of voters -- Table is Voters. There is a field called "party", where party can be "REP","DEM", "UNA" -- looking to construct a pie chart the shows the % of the pie for each slice ... that is, for the found set I can see the % of DEM, REP and UNA ... 

      1. Created a new field in the database "ByPartySumCountOf", type "Summary", count of party.

      2. Created a new layout, with the chart ... chart type Pie

      3. Label Data:  Voters::party .... Value Data: ByPartySumCountOf

      4. Use Data from: Current Found Set

      Any Thoughts? (I can reduce # records and get a pie chart but I get a slice for every record.) ..Thanks

      Results: 

      ByParty.jpg