Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Senthil,
The following link may help you, which i have created few months back.
Cheers,
Ganesh.
for your scenario , create Hour field by taking ALERT_DATE. by using bellow pseudo code
timestamp() or
time(field,'HH')
cheers