Need line chart, multiple data series
Below this description is a table with the data I'm trying to graph in various ways. It's a project where each client goes through a number of neurofeedback sessions and provides a self-reported score on how they're currently feeling about a problem area (a "Treatment Goal" or TG). So for example, in the first two data rows, Client ID 101, in Session Num 1, reported scores on two TG's: Attention (Score of 8) and Sleep (Score of 6). He had the same pattern of data points through 4 sessions.
Client 102 had three TG's on his first session (session num 1): attention, anxiety, and rumination. But you'll see when we get to his 4th session, he has added an additional TG: Sleep. There may also be some gaps in the data series (e.g., maybe client 101 didn't report a score for one TG for a particular session).
I want line charts, and I'm using FileMaker Pro 11. I can already pretty easily create a line chart that will show one data series for one client and one TG, say Client 101's Attention scores.
What I'm having trouble doing is getting satisfactory line charts with more than one data series. At this point the data points are ALWAYS going to be from the "Score" field, and the X-Axis labels are ALWAYS going to be "Session Num." What I'd like to be able to do is easily create charts for multiple clients who have the same treatment goal, and charts for one client showing all of their treatment goals. So for example, a line chart showing a line for all clients who have a problem with "Sleep" (each client's scores for Sleep represents one data series). Or I'd like to be able to show all the scores for all treatment goals for one client (so I'd have one chart that shows everything that client 101 is working on, with one line per treatment goal).
I used to be pretty comfortable with FileMaker in years past (through version 6, I think) but put it aside for a while and am now coming back to it, and the charting feature is totally new to me.
Also, if any of you happen to be Excel gurus and know of an easy way to do this in Excel, I'd be happy to hear that, too. Thanks!
|Session Num||Client ID||Score||TG Description|