Jump to content

Newb - Pie Chart Repeating Field (List)


hnickm

This topic is 3052 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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 by LaRetta
Link to comment
Share on other sites

This topic is 3052 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.