Hello community,Hope you are all well
I have following data format where we have a client ,hotel they stayed ,first registered, stay from ,stay to
| client |
hotel |
first registered |
stay_from |
stay_to |
readmission |
| a |
itc |
30/11/2022 |
30/11/2022 |
14/12/2022 |
yes |
| a |
itc |
30/11/2022 |
30/12/2022 |
16/02/2023 |
yes |
| a |
taj |
30/11/2022 |
16/02/2023 |
24/02/2023 |
no |
If client is staying in a hotel from multiple times in a same hotel it is readmission in hotel,
eg:client a stayed in hotel itc from 30/11/2022 to 14/12/2022 and he then again came back to this place on 30/12/2022 and stayed here 16/02/2023
I am calculating this using this formula
=if(count(distinct total<client,hotel>client&hotel&stay_from )>1,'Yes','No')
Which gives gives me the above table,
I want to see if there was a readmission in 7 days which is i want to calculate (30/12/2022-14/12/2022 <=7 ) then yes else no,
| client |
hotel |
first registered |
stay_from |
stay_to |
readmission |
Readmission in 7 days |
| a |
itc |
30/11/2022 |
30/11/2022 |
14/12/2022 |
yes |
no |
| a |
itc |
30/11/2022 |
30/12/2022 |
16/02/2023 |
yes |
no |
| a |
taj |
30/11/2022 |
16/02/2023 |
24/02/2023 |
no |
no |
I hope i was clear if not please let me know
Note: Please tell me how to approach this in front end,
