Hello everyone..
Want to create one dimension like bucket of days. I have 2 date column date1 and date2
want to calculate days difference like - max(date1)-date2
i have created one variable vmaxDT with exp = max(date1)
and dimension should be like this..
=if((vmaxDT -date2) <=0,Dual( 'No Due',1),
if((vmaxDT -date2) >=1 and (vmaxDT -date2) <=30,Dual('0 To 30',2),
if((vmaxDT -date2) >30 and (vmaxDT -date2) <=60,Dual('31 To 60',3),
if((vmaxDT -date2) >60 and (vmaxDT -date2) <=90,Dual('61 To 90',4),
if((vmaxDT -date2) >90 and (vmaxDT -date2) <=180, Dual('91 To 180',5),
if((vmaxDT -date2) >180 and (vmaxDT -date2) <=365,Dual('182 To 365', 6),
if((vmaxDT -date2) >365,Dual('Above 365',7)))))))) as Bucket
But this is not working properly. On the selection/filter basis bucket and data is getting fluctuate.
(like '31 To 60' bucket's some of data is getting display into another bucket like wise happening for other buckets as well
please help into calculate days bucket dimension
