Forum Discussion

Anonymous

Not applicable

6 years ago

Rolling 4 weeks calculation

Hi, I am calculating Rolling 4 weeks data based on below W1=W1 W2=W1+W2 W3=W1+W2+W3 W4=W1+W2+W3+W4 W5=W2+W3+W4+W5(Starting from W2) ..... W1 is 01-Jan-2020 to 07-Jan-2020 W2 is 08-Jan-2020 ...

Community Support

6 years ago

Hi Anonymous ,

I think this might be caused by weeknum, I find that you seem to re-define the week num, and today(5/20) should be in 21 week. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable
6 years ago
dax ,
I am calculating weeks based on the customer requirment.
i.e: Week1 (01-Jan-2020 to 07-Jan-2020)
Thats why we are getting week numbers like this.

Best Regards,
Prasad
- amitchandak
  Super User
  6 years ago
  Anonymous , these week are always Wed-Tue or only for this year ??
  
  In any case if you have week start date you should able create the rank and other column to get desired data
  - Anonymous
    Not applicable
    6 years ago
    amitchandak , For all years weeks will have same days(7 days).
    like week1 (1 jan to 7 jan)
    
    Best Regards,
    Prasad
- dax
  Community Support
  6 years ago
  Hi Anonymous ,
  
  Did you try my sample data? I re-define the calendar date ( each 7 days as a week from start of year). You could check whether this is what you want.
  
  Best Regards,
  Zoe Zhi
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.