Jump to content
Sign in to follow this  
abby_md

charting counts by month

Recommended Posts

Hi all!
 
I have a database to log patients in a clinic with the following fields:
 
DateSeen
PatientNo
Classification (Two types of Patients: Private and Charity)
 
Is it possible to create a chart that shows the number of Private patients and number of Charity patients per month in one chart?
 
Thank you so much in advance!
-----------------------
 
And if it's not too much to ask, here's another scenario:
 
I have a parent table PatientProfile with the following fields:
DateSeen
PatientNo
Classification (Two types of Patients: Private and Charity)
 
and a Related table Consults:
PatientNo (that relates to the parent table)
DateOfConsult
ConsultType (InPatient or Outpatient)
(so each patient can have several consults with varying types)
 
Is there a way for me to tally PER MONTH the number of the following and put it in one layout:
Total Number of Private Patients
Total Number of Charity Patients
Total Number of InPatients and broken down into:
     Private InPatients
     Charity InPatients
Total Number of OutPatients and broken down into:
     Private OutPatients
     Charity OutPatients
 
Thank you again

Share this post


Link to post
Share on other sites

I am afraid that's too many questions for one thread. Even your first question has several issues, none of which is exactly trivial:

  1. How to summarize records by (calculated) month?
  2. How to produce individual monthly counts by category?
  3. How to show these counts as individual data series in a chart?

I suggest you study the attached file for answers to these questions. Hopefully this will also help with your other scenario.

CompareMonthlyCategories.fp7.zip

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.