cancel
Showing results for 
Search instead for 
Did you mean: 

Ressource planning based on patient course in WebI

hraustur2021
Discoverer
0 Kudos

* 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!

Former Member

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

Best,

Your SAP Community moderator

Accepted Solutions (0)

Answers (0)