priyankjayna

Graphs

Discussion created by priyankjayna on Aug 31, 2017

Hi

 

i have two related tables 

Table - patient detail

Fields         patient name

                    Patient id

 

Table - Payment

   Fields       patient name

                    Patient id

                    Date of payment

                    Amount

 

Patient name and Patient ID are related in both the table. Also each patient can do multiple payments on multiple dates.

 

I want to make a graphs of

    - total amount of payment received per month for a selected year (one should be able to enter which year graph is needed)

    - total amount of payment received per year (use all the data)

 

also i wish to find  how many new patients started (count / number) . this is number of patients doing the first payment

 

then the graph of

     - the  number of new patients per month for selected year (one should be able to enter which year graph is needed)

     - the  number of new patients yearly

Outcomes