Calculating a Graph

Discussion created by MattLeach on Jan 16, 2012
Latest reply on Jan 17, 2012 by MattLeach

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?