Newb - Pie Chart Repeating Field (List)

[hnickm]

Newb here. I have a database of neighborhoods. Each record has the house number (address) for each house in the neighborhood in a repeating field. There is another repeating field with status (no work, in progress, done). I'd like to get a pie chart for each neighborhood showing the percentage of the status field of the three categories. I made a list field for the status field, but I can't get a pie chart showing the percentage of each of the three status categories. 

Any help appreciated.

Thanks,

HNick

[LaRetta]

Hi!  Welcome to FMForums! :-)

Repeating fields are not the tools for this, as you have quickly discovered already.  Each house should be a record in a Houses table and they would hold the NeighborhoodID from the Neighborhoods table along with the house Status field, creating a one-to-many structure (many houses to one neighborhood).  Once your structure is straight, a pie chart of Houses would be simple.

Edited October 23, 2015 by LaRetta

[hnickm]

Thanks LaRetta,

I knew I was doing something wrong, but not what.

I will take this approach.

HNick