Skip to Content
0
Feb 02, 2021 at 07:28 PM

Ressource planning based on patient course in WebI

157 Views Last edit Feb 03, 2021 at 10:35 AM 2 rev

* I am new to Web Intelligence *

I have data on patients who started a certain treatment: Patient IDs and the date of each referral.

I have a list of all appointments ("First meeting with doctor, 60 minutes, 1 month after referral", "Treatment start, 120 minutes, 2 months after referral", etc.) which I need to plot for each patient in order to map the expected ressources needed in the next 3 months.

I have made variables for each part of the treatment in the format as follows:

Date 1st Appt = RelativeDate([Referral Date]; 30)

Date 2nd Appt = RelativeDate([Referral Date]; 60)

Ressources 1st Appt (minutes) = Count (Patient ID) * 60 ForEach ([Date 1st Appt])

Ressources 2nd Appt (minutes) = Count (Patient ID) * 120 ForEach ([Date 2nd Appt])

etc.

I intend to make a graph for the next 3 months where I plot all the minutes against a time dimension on the x-axis with all the dates. It works fine when I plot each appointment on its own (Ressources 1 Appt / Date 1st Appt). However, when I plot all together the dates get "mixed up". Instead of the 2nd appoinment being 30 days later than the 1st appointment, they all land on the same date.

Can someone help me figure out what I am doing wrong. As mentioned, I am quite new with WebI, so I probably just need some basic ideas.

Thanks in advance!