Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am calculating the duration in minutes. means close date and enter date the duration is interval (close date- enter date, 'mm'). using this expression to calculate the duration in minutes. divide the close date and enter date into buckets like
15 minutes,
1 Hour,
24 Hour
> 24 Hours
temp:
LOAD serviceid,
[date-entered],
date_closed
if(Interval(date_closed-[date-entered],'mm')<= tmie#(15,'mm'),'<= 15minutes',
if(Interval(date_closed-[date-entered],'mm')> tmie#(15,'mm') and Interval(date_closed-[date-entered],'mm')<=tmie#(60,'mm') ,'<= 1 Hr',
if(Interval(date_closed-[date-entered],'mm')> tmie#(60,'mm') and Interval(date_closed-[date-entered],'mm')<=tmie#(1440,'mm') ,'<= 24 Hr',
if(Interval(date_closed-[date-entered],'mm')> tmie#(1440,'mm') , '> 24 Hr',)))) as category,
interval(date_closed - [date-entered]) as duration
FROM
(ooxml, embedded labels, table is Sheet3);
<= 15 minutes |
<= 1Hr |
> 24 Hrs |
- |
in that expression the Interval(date_closed-[date-entered],'mm') is divide into category.the data fetching only '<= 15 minutes', '<= 1 Hr', '> 24 Hr' but not fetch the data ' <= 24 Hr' .the duration is divided into category is correct or not otherwise any one plz tell me right way for that solution
Thank you Massimo