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?