Recovery curve

Question

hi all,&nbsp;i have a table with all our sickness data and i want to create a yearly recovery curve. The table looks like this;&nbsp;Sickness IDStart dateRecovery dateIs Recovered# Sickness days00101-01-202101-09-2021124400201-10-202102-10-20211200301-11-202108-11-20211800401-05-2021&nbsp;&nbsp;&nbsp;00501-07-202101-09-202116300601-01-202201-02-202213200701-03-20224-03-20221400801-04-202201-04-20221100901-05-2022&nbsp;&nbsp;&nbsp;01001-05-202020-03-20221689Etc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This table contains about 500k rows 🙂&nbsp;i want to create the number of recovered cases as % of the total number of recovered cases in a year, per day, so:&nbsp;2021: number of recovered cases = 4 ( formula = calculate(sum(isRecovered),userelationship(date table(date),recovery date))2022: number of recovered cases = 4&nbsp;Day12345678910072020210%25%25%25%25%25%25%50%50%75%100%202225%25%25%50%50%50%50%50%50%75%100%&nbsp;So i want a X axis with number 1 to 720 (maximum # number of sickness days in our country) and on Y axis the cumulated recovery %.&nbsp;&nbsp;Does anybody have a solution for the second formula to create a cumulated recovery line?&nbsp;Many thanks in advance,&nbsp;Regards,Frank

anonymous · Accepted Answer

HI
&nbsp;
I get this for you in 2 measures

Percentagerecov2021 = 
VAR compteurvalue =
&nbsp; &nbsp; SELECTEDVALUE ( Compteur[Value] )
VAR nbrecovtotal =
&nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; SUM ( Recovery[Is Recovered] ),
&nbsp; &nbsp; &nbsp; &nbsp; Recovery[Yearsd] = 2021
&nbsp; &nbsp; )
VAR result =
&nbsp; &nbsp; DIVIDE (
&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM ( Recovery[Is Recovered] ),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Recovery[Yearsd] = 2021
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; Recovery[# Sickness days] &lt;= compteurvalue
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )
&nbsp; &nbsp; &nbsp; &nbsp; ),
&nbsp; &nbsp; &nbsp; &nbsp; nbrecovtotal
&nbsp; &nbsp; )
RETURN
&nbsp; &nbsp; result
&nbsp;

Percentagerecov2022 = 
VAR compteurvalue =
&nbsp; &nbsp; SELECTEDVALUE ( Compteur[Value] )
VAR nbrecovtotal =
&nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; SUM ( Recovery[Is Recovered] ),
&nbsp; &nbsp; &nbsp; &nbsp; Recovery[Yearsd] = 2022
&nbsp; &nbsp; )
VAR result =
&nbsp; &nbsp; DIVIDE (
&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM ( Recovery[Is Recovered] ),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Recovery[Yearsd] = 2022
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; Recovery[# Sickness days] &lt;= compteurvalue
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )
&nbsp; &nbsp; &nbsp; &nbsp; ),
&nbsp; &nbsp; &nbsp; &nbsp; nbrecovtotal
&nbsp; &nbsp; )
RETURN
&nbsp; &nbsp; result
&nbsp;
I just add a column with the year on the table

&nbsp;

Forum Discussion

Recovery curve

2 Replies

Related content

S - Curve

Disaster Recovery in Fabric

Gateway Recovery Key

File recovery

Fabric-Disaster Recovery

Sickness ID	Start date	Recovery date	Is Recovered	# Sickness days
001	01-01-2021	01-09-2021	1	244
002	01-10-2021	02-10-2021	1	2
003	01-11-2021	08-11-2021	1	8
004	01-05-2021
005	01-07-2021	01-09-2021	1	63
006	01-01-2022	01-02-2022	1	32
007	01-03-2022	4-03-2022	1	4
008	01-04-2022	01-04-2022	1	1
009	01-05-2022
010	01-05-2020	20-03-2022	1	689
Etc

Day	1	2	3	4	5	6	7	8	9	100	720
2021	0%	25%	25%	25%	25%	25%	25%	50%	50%	75%	100%
2022	25%	25%	25%	50%	50%	50%	50%	50%	50%	75%	100%