I have the following table:
-
- Patient
-
- Death (boolean)
-
- Treatment start date (day 2023-03-20)
-
- Date of death (day 2023-04-20)
-
- Duration (int - difference in days between Treatment start date and Date of death)
-
- Month (first day of the month: 2023-04-01)
-
- Hospital (string)
I want to create a chart that shows how many patients from same month survived after X days:
- Hospital (string)
- X axis - time after treatment start ( 0, 1, …, 100, 365,…)
- Y axis - Patients alive
Ex: At time 0 all patients(y=10) are alive, at time 10 one patient died y=9.
Should I create a calendar table?