Create a realtime graph calculating the percentage of certain criteria

[Mountain]

I have records that I have a recorded result in a field "food"

As I would take in orders they would label the sale of a food with the following

"Hamburger"

"Cheeseburger"

"Hot Dog"

"Grilled Cheese"

"Philly Steak"

 

I would like to have a real time graph constantly counting each Item and graphing it is some way (always updating ) within the record. And continuing to do so as we add records.

How do I do this with a calculation? Count the number of Hamburger cheeseburger, hot dog, Grilled Cheese, philly steak order and graphing the percentage. I can understand how to graph in filemaker but I dont' know how to calculate for the pie chart? How can I calculate the percentages?

Thanks

 

 

 

 

 

 

[Mountain]

I tried doing a find for each food, then getting a count of the number of records. That far I can see that we sold for example 23 hamburgers and with that I can say there are 140 records for example , and given that there was 23 hamburgers sold, they would constitute 16 percent of the days sales. This is achieved by dividing  2300 by 140. In this example. I would have to do this process for each food and then graph it. Where do I store the results of the process so that each can be compared?  Is this the best way to do this given my last post?