Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Wow.. it works!! the only change was the duration which i changed from 4 to 14.