Weekly Streak

[Anonymous]

Is it possible to get a weekly streak for this data? 

Date	Result	Category	Target
December-06-19	0.915718	Service Level	0.8
December-05-19	0.862132	Service Level	0.8
December-04-19	0.794658	Service Level	0.8
December-03-19	0.78	Service Level	0.8
December-02-19	0.76	Service Level	0.8
November-29-19	0.92779	Service Level	0.8
November-28-19	0.889925	Service Level	0.8
November-27-19	0.778535	Service Level	0.8
November-26-19	0.78	Service Level	0.8
November-25-19	0.845833	Service Level	0.8

Thanks.

[az38]

Hi @Anonymous 

what is the "weekly streak"? what exactly result do you expect?

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

@az38 

For weekly streak I mean like if the result is greater than target, then 1 point is added to each day so the maximum streak for the week would be 5. And also if the streak is at 2 and then the result is below target, the it would be 0 and the -1 the next day if the result is still less than target. Here is how the data should look like at the end.

Date	Result	Category	Target	Weekly streak
December-06-19	0.915718	Service Level	0.8	1
December-05-19	0.862132	Service Level	0.8	0
December-04-19	0.794658	Service Level	0.8	-2
December-03-19	0.78	Service Level	0.8	-1
December-02-19	0.76	Service Level	0.8	0
November-29-19	0.92779	Service Level	0.8	1
November-28-19	0.889925	Service Level	0.8	0
November-27-19	0.778535	Service Level	0.8	-1
November-26-19	0.78	Service Level	0.8	-1
November-25-19	0.845833	Service Level	0.8	0