This content has been marked as final. Show 2 replies
Just a couple of suggestions if I understand what you are trying to analyze:
- You can peg the position of each patient on the 1st year he/she being tracked (high, medium or low risks) and then summarize how many % of the total patient improve in 1 year, 2 years, 3 years time etc.
- A different analysis that you can do is to break it down year-over-year how many stay at high risks, how many % improved 1 level (high to med), vs 2 levels (high to low)
A waterfall chart can be used to illustrate nicely.
Thank you Lubis. Sorry I have been away and now working on a different problem. I will try out your suggestions.