AnsweredAssumed Answered

Monthly and Yearly Graphs

Question asked by priyankjayna on Nov 23, 2017
Latest reply on Nov 23, 2017 by philmodjunk

hi i have a filemaker database with four related tables

Patient details : ID, Name, address, date of birth, sex

Bulk payment : BPAmount , BPDate,  ID, Name

Monthly payment : MPAmount, MPDate,  ID, Name

Other payments : OPAmount, OPDate,  ID, Name

 

I need to make the following 6 graphs

 

1) Total Bulk per month from Bulk payment for a particular year

2) Total Bulk per year from Bulk payment Should ask which year the graph is required

 

3) Total income per month for a particular year (from sum of the three tables bulk, monthly and other)

4) Total income per year (from sum of the three tables Initial, monthly and other) Should ask which year the graph is required

 

 

5) Total no of NEW patients per month :  found from first payments received per month for a particular year (first payment can be any of the three tables)

6) Total no of NEW patients per year :  total first payments received per year (first payment can be any of the three tables) Should ask which year the graph is required

 

 

Kindly help me out

Outcomes