Forum Discussion

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
5 years ago
Solved

Binning

Hi,

 

I am trying to use compartments against dates (groups by fourteen days).
I wanted to know if it was possible to postpone the groupings by 7 days so that the information provided correspond to the dates of my meetings.
For example I want the start of my first fortnight to start on January 11th. Is it possible ?
Thanks in advance.

 

Alexis

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    AlexisPREVOT , for date > 2021-01-11 you can do like

     

    new column = quotient(datediff([date],date(2021,1,11),day),14)+1

     

    or

    new column if([date]>=date(2021,1,11) ,quotient(datediff([date],date(2021,1,11),day),14)+1 ,blank())

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    AlexisPREVOT , for date > 2021-01-11 you can do like

     

    new column = quotient(datediff([date],date(2021,1,11),day),14)+1

     

    or

    new column if([date]>=date(2021,1,11) ,quotient(datediff([date],date(2021,1,11),day),14)+1 ,blank())