Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Weekly Streak

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

 

Date      Result CategoryTarget
December-06-190.915718Service Level0.8
December-05-190.862132Service Level0.8
December-04-190.794658Service Level0.8
December-03-190.78Service Level0.8
December-02-190.76Service Level0.8
November-29-190.92779Service Level0.8
November-28-190.889925Service Level0.8
November-27-190.778535Service Level0.8
November-26-190.78Service Level0.8
November-25-190.845833Service Level0.8

 

Thanks.

Need Help

2 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

       

      DateResultCategoryTargetWeekly streak
      December-06-190.915718Service Level0.81
      December-05-190.862132Service Level0.80
      December-04-190.794658Service Level0.8-2
      December-03-190.78Service Level0.8-1
      December-02-190.76Service Level0.80
      November-29-190.92779Service Level0.81
      November-28-190.889925Service Level0.80
      November-27-190.778535Service Level0.8-1
      November-26-190.78Service Level0.8-1
      November-25-190.845833Service Level0.80