4 Replies Latest reply on Jun 20, 2017 1:50 PM by amulya.sharma

Obtain Singular Dimensional Outcome based on multiple results and Aggregate the per person Outcomes

Hi everyone,

In the attached 10.0.2 workbook, I've run into a tricky situation while working with two similar dimensions - Employment Status and Living Arrangement Status. Both these dimensions can have 3 values - Gotten Worse, Stayed the Same and Improved. And for each person, the results are collected and assessed over multiple visits and each follow-up visit has this dimension answered with respect to the just prior visit.

Eg: Person A has 1st Visit saying Employment Status Improved, 2nd Visit - Stayed the Same (w.r.t. to 1st Visit), 3rd Visit -(Stayed the same (w.r.t. 2nd Visit) and so on..

Now if I try and aggregate all results based on individual dimensional values to measure something like Treatment Impact (What % of all patients showed Improvement, Did not change, Or got worse?), it will skew the data towards a particular dimensional value (Eg: if suppose Person A keeps answering "Stayed the Same" for Employment/L.A. multiple times). And that'll not tell the real story for Treatment Impact.(See existing worksheets) In reality, they were answering "Stayed the same" w.r.t. Improvement at a prior visit. Also, I'm not sure what to do with Person 19 either (Improved -> Stayed the same -> Stayed the Same -> Worsened).

How do I show Treatment Impact using a chart with this data, showing me a singular accurate result per person, based on all their results off all their visits? Basically get one overall result per person and aggregate that. Is this even possible with this data? I'll appreciate it. Thank you!

• 1. Re: Obtain Singular Dimensional Outcome based on multiple results and Aggregate the per person Outcomes

Hi Amulya

Not sure if it helps, but can give you some tarting point. Check Screenshot and attached.

Thanks

Deepak

• 2. Re: Obtain Singular Dimensional Outcome based on multiple results and Aggregate the per person Outcomes

Starting point I mean

• 3. Re: Obtain Singular Dimensional Outcome based on multiple results and Aggregate the per person Outcomes

Hi, Amulya

I agree with Deepak Rai, we are not clear about what's your starting point.

According to your description, when a person previously said improved and then if the next visit saying stayed the same means improved, we can get a calculation to work out this logic as shown in below snapshot  (highlighted with person id 9 and 17).

ZZ

1 of 1 people found this helpful
• 4. Re: Obtain Singular Dimensional Outcome based on multiple results and Aggregate the per person Outcomes

Zhouyi Zhang

Although all results are w.r.t to the first result for each person, aggregating those would be a problem in the way the results are listed. Hence I thought of a business logic to aggregate this:

For every Person,

1) If all results/person are Stayed the same, then only should final result for that person be "Stayed the same"

2) If Worsened/Improved are in the result set for a person, the final result should be the latest Worsened/Improved result for that person.

Eg: Person 14 final result -> Stayed the same, as per (1)

Person 19 final result -> Worsened, as per (2)

Person 17 final result ->  Improved, as per (2)

Then I would aggregate the 'final results' per person to get an overall picture. I think this covers all possibilities for the results. If someone can guide me on how to implement this in a Calculated field, that would be terrific. Thanks.