Binning

[AlexisPREVOT]

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

[amitchandak · Accepted solution]

@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())

[AlexisPREVOT]

Thank you @amitchandak