Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a master calendar and a po date.
i want to create a bucket of the difference of the two date.
so if the difference of two is 22 it should fall in 0-30 bucket.
When i try using Class or interval function in dimensions it says error in calculated dimension.
Regards,
Try below,
Or share a sample data and expected output.
If(Day >= 0 and Day <= 1, Dual('0-1days',1), If(Day>=2 and Day <= 8, Dual('2-8days',2), If(Day >=9 and Day <=11,Dual('9-11days',3)))) as Day_Bucket;
Load PO, PODate, Day(PODate) as Day;
Hi rahul,
May be like Following Way:
I
=if(Date-podate <=20,'A.0-20',
if(Date-podate <=30,'B.21-30','C. >30') ) as [Bucket]
thanks,
Arvind Patil
Instead in dimension, use class function in script and then use it as dimension
Hi Rahul,
Class(DateDiff,30) should work as a calculated dimension. What expression did you use?
Regards
Andrew