Question on presenting data

[gromboy]

Hi,
I have a chemotherapy database which has treatment cycle information. For example the patient may come today on Day 1, in a week for Day 8 etc.. During this time nurses may record whats called toxicity scoring, eg for vomiting 1-4 based on severity etc.. or hair loss, diarhoea etc

I can do reports on trends for the toxicity but including when the cycle took place on the same chart is proving difficult....

I just wondered if anyone can suggest a method which would work ?

I guess what would be ideal is a line graph with say 4 lines (one for each type of toxicity) then on the graph a spike or star or something which denoted when they have had a treatment day...
Any suggestions welcomed as ever
Steve

 

[lbass]

If you have a date field {table.alldates} that displays for every date, use that for the "on change of" field. Then add your four toxicity summaries. Then create a formula {@null} by opening and saving a formula without entering anything. Then create separate formulas for each toxicity like this, assuming you have a separate date field related to the treatment:

if {table.alldates} = {table.treatmentdate} then
{table.toxicityscore1} else
tonumber({@null})

Add this to your line chart and then right click on the series and choose "series options"->line style->markers only. Repeat for each toxicity type.

This will add markers on each toxicity line where there is a treatment date.

-LB

 

[gromboy]

Thanks for your quick reply...I'll see if I can do what you've suggested..
many thanks
Steve

 

[gromboy]

Hi LB,
I've finally got back to this issue !

I don't have a {table.alldates} field, only a TEST_DATE field for the toxicity test date, and an APPT_DATE for the appointment date.

Is there another way ?
Steve