I've been asked to setup a graph in our system to show the total amount of expected income for each month. Up to this point i have very minimal experience with FileMaker's graphing capabilities so i'm a bit new to this part.

Each record in our database contains 2 fields:

MonthlyAmt = The amount the client pays each month

SWPD2 = The date that the client is paid up through (this date will always be the end of a month)

To suffice my boss's need for this right away, i was able to export the information and quickly create a graph in excel as i'm very fluent in excel and knew i could get it done quickly.

I now need to make this graph real-time, so the only solution would be a graph within our database.

What would be the best way to approach this? I'm assuming i would need a summary field that calculates the total amount based on the paid through date?

Thanks

How does one know when did the client

startpaying?