To group a numeric column containing the difference between 2 dates into same_day, day+1, >1 day

[Bu__]

i want to convert a numeric column containing difference between 2 dates like (0,1,2,3..... so on) into 3 groups --> same_day, d+1 and >1 day

How to convert the numeric column and categorize them into 3 groups?

days between (difference b/w 2 dates)|  ---> | 3 categories

0                                                                            same day

1                                                                            D+1 day

2                                                                             >1 day

3                                                                             >1 day

....

6                                                                             >1 day

[tamerj1 · Accepted solution]

Hi @Bu__ 

please try
=
SWITCH (

[days between],
0, "same day",

1, "D + 1 day",

"> 1 day"

)

[FreemanZ · Accepted solution]

hi @Bu__ 

try like:

categories =

SWITCH(

    TRUE(),

    [days between]=0, "same_day",

    [days between]=1, "d+1", 

    ">1 day"

)

[tamerj1 · Accepted solution]

Hi @Bu__ 

please try
=
SWITCH (

[days between],
0, "same day",

1, "D + 1 day",

"> 1 day"

)