Hello Community members,
Many thanks for your help. i am working on a visualisation which is based on dates & it should bucketize based on 14 days starting from minimum date available in any dimension.
Lets say if i have a date field which starts with 01-Jun-2018.. i need to bucketise it as following:
starting from 1st day(minimum) to next 14 days
then next 14 days starting from next day.... and so on.
| Date |
| 01/06/2018 - 14/06/2018 |
| 15/06/2018 - 28/06/2018 |
| 29/06/2018 - 12/07/2018 |
| 13/07/2018 - 26/07/2018 |
| 27/07/2018 - 09/08/2018 |
| 10/08/2018 - 23/08/2018 |
| 24/08/2018 - 06/09/2018 |
| 07/09/2018 - 12/09/2018 |
Is there any way to do it? Please share it with me. It will be a great help!!
Best Regards,
Rahul Goyal
