Options

How to create weeks in between epoch calender?

Anil_DangatAnil_Dangat Member Posts: 1 Newbie
Hello Community,

I have machines data calender weeks from 1 jan 2019 to 31 december 2019,which has  52 calender weeks.but my machin has built in 25 th september 2019 and i would like consider data from 25th september as a week 1 and would like to take next data as weekwisw 2,3,4,5etc.
need help asap.please write code if needed.

thank you


Answers

  • Options
    ceaperezceaperez Member Posts: 522 Unicorn
    Hi @Anil_Dangat,
    a possible approximation is to use a kind of normalization, you can subtract the the n-1 week number to the real week number, your target point, using the generate attribute operator. 
    please find attached a simple example.

    Best, 
    Cesar
Sign In or Register to comment.