Class

[#1]

ACT_DATE	ALT_DATE	DIFF	AACTION	MAR	ALERT_DATE	ALERT_ACTION_DATE	ALT_ACTN_USER_ID	BUS_UNIT_DESC	COUNTRY_CODE
2-Feb-15	31-Jan-15	2	OK	150131SCBLCIABAXXX3540298443	2015-01-31T10:51:34.36Z	2015-02-02T06:49:45.49Z	1498984	Payments	IC
2-Feb-15	31-Jan-15	2	OK	150131SCBLCIABAXXX3540298443	2015-01-31T10:51:34.36Z	2015-02-02T06:49:45.49Z	1498984	Payments	IC
2-Feb-15	2-Feb-15	0	OK	150202SCBLCIABXXXX0052718356	2015-02-02T01:00:21.40Z	2015-02-02T06:50:16.83Z	1498984	Trade	IC
2-Feb-15	2-Feb-15	0	OK	150202SCBLCIABXXXX0052718356	2015-02-02T01:00:21.40Z	2015-02-02T06:50:16.83Z	1498984	Trade	IC
2-Feb-15	2-Feb-15	0	OK	150202SCBLCIABAXXX3541298452	2015-02-02T07:28:20.85Z	2015-02-02T07:55:08.09Z	1498984	Payments	IC
2-Feb-15	2-Feb-15	0	OK	150202SCBLCIABAXXX3541298448	2015-02-02T02:06:45.50Z	2015-02-02T08:27:46.71Z	1415664	Payments	IC
2-Feb-15	2-Feb-15	0	ERRIDE	150202SCBLCIABAXXX3541298448	2015-02-02T02:06:45.50Z	2015-02-02T08:27:46.71Z	1415664	Payments	IC

Requirement is :

I have to Find the No of MAR and the average time between ALERT_DATE and ALERT_ACTION_DATE on a hourly basis

Eg: creating Buckets based on  Hour of ALERT_DATE

[ganeshreddy]

Hi Senthil,

The following link may help you, which i have created few months back.

Bucket Creation In List Box

Cheers,

Ganesh.

[ganeshreddy]

for your scenario , create Hour field by taking ALERT_DATE. by using bellow pseudo code

timestamp() or

time(field,'HH')

cheers