Set Analysis Help

[nirav_bhimani]

Hi Everyone,

Following is my Pivot table in that I want to calculate the time difference bet each event. I have used the interval() and above() fuction to get the output, It works if i take only one dimension i.e.event, If I add more dimension then my expression doesnt work.

if(RowNo(TOTAL)=1,null(), Interval(Timestamp(EVENT_DATE) - Timestamp(Above(EVENT_DATE)),'d hh:mm'))

Container Number	EVENT	EVENT_DATE
A	A1	05-12-2012 13:56
A	A2	05-12-2012 21:59
A	A3	05-12-2012 04:30
A	A4	04-12-2012 21:00
A	A5	05-12-2012 02:00
A	A6	05-12-2012 20:58
A	A7	05-12-2012 14:15
A	A8	11-12-2012 06:59
A	A9	06-12-2012 11:00
A	A10	06-12-2012 11:01
A	A11	05-12-2012 12:56
A	A12	05-12-2012 06:05
A	A13	05-12-2012 03:30
A	A14	05-12-2012 06:00
A	A15	19-12-2012 05:36
A	A16	07-12-2012 16:00
A	A17	05-12-2012 04:40
A	A18	05-12-2012 12:47
A	A19	20-12-2012 05:37
A	A20	09-12-2012 13:35
A	A21	07-12-2012 16:30
A	A22	09-12-2012 16:11

Please help me.

Thanks & Regards,

Nirav Bhimani

[Anonymous]

hi,

    Please check the application,problem is above function is work only for in report minimun two dimensions are needed.

Regards

[Gysbert_Wassenaar · Accepted solution]

If you have more than one dimension use the total keyword in the above function.

You could also try calculating the time between events in the script, but it's unclear to me what the order of the events is. The event dates certainly aren't chronological.

[Oleg_Troyansky]

try using a prefix TOTAL within your function above(), most likely you are getting the wrong results because of the second dimension.

[nirav_bhimani]

Hi everyone,

Thanks for your help, I need further help. I am getting the date difference in days but my problem is when the container is different then it should not take the last date of previous container for a diffrence. Is it possible with set analysis expression?

Thanks & regards,

NIrav Bhimani