Store KPI metric from previous weeks

[jalaomar]

Hi all,

Need some help on how to store KPI results from previous weeks.

Have a dataset connected to a server which is being updated every week. so when the dataset is refreshed, it overwrites previou weeks data. 

but i would like to store previous weeks of KPI results. anyone who know how to manage this? 

Week 2: 33%

Material number	Created date	Document approved
a	2023-01-01	No
b	2023-01-10	Yes
c	2023-01-14	No

Week 3: 67%

Material Number	Created Date	Document approved
a	2023-01-01	Yes
b	2023-01-10	Yes
c	2023-01-14	No

Outcome KPI trend

Week	Result
2	33%
3	67%

Anyone that would know how to capture previous weeks/months/year KPI results?

BR

J