TravelerOn
Registered User.
- Local time
- Today, 07:04
- Joined
- Dec 17, 2001
- Messages
- 21
Okay, I feel like this should be terribly simple, but I can't seem to work it out.
I have a DB that tracks data in a patient survey by month. In other words, Patient ID, Patient Name, and then a series of questions about the effectiveness of their treatment, rated on a scale of 1-10. So the fields are
Numbness [Values 1-10]
Tingling
Sharpness
Burning
Overall
So Patient 1 has 10 for numbness, 9 for tingling, 2 for sharpness, etc.
I want a report that shows me a chart per patient ID, with the y-axis being values 1 through 10, and the x-axis showing Numbness, Tingling, Sharpness as discrete bars with different colours. Is there a way to do this? Previously we exported the numbers to an Excel Spreadsheet and then built the reports that way, but it was tedious.
I have a DB that tracks data in a patient survey by month. In other words, Patient ID, Patient Name, and then a series of questions about the effectiveness of their treatment, rated on a scale of 1-10. So the fields are
Numbness [Values 1-10]
Tingling
Sharpness
Burning
Overall
So Patient 1 has 10 for numbness, 9 for tingling, 2 for sharpness, etc.
I want a report that shows me a chart per patient ID, with the y-axis being values 1 through 10, and the x-axis showing Numbness, Tingling, Sharpness as discrete bars with different colours. Is there a way to do this? Previously we exported the numbers to an Excel Spreadsheet and then built the reports that way, but it was tedious.