Jump to content

charting counts by month


This topic is 2024 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
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
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

Link to post
Share on other sites

This topic is 2024 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

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