2 Replies Latest reply: Jun 15, 2015 8:54 AM by Ganesh Reddy RSS

    Class

      ACT_DATEALT_DATEDIFFAACTIONMARALERT_DATEALERT_ACTION_DATEALT_ACTN_USER_IDBUS_UNIT_DESCCOUNTRY_CODE
      2-Feb-1531-Jan-152OK150131SCBLCIABAXXX35402984432015-01-31T10:51:34.36Z2015-02-02T06:49:45.49Z1498984PaymentsIC
      2-Feb-1531-Jan-152OK150131SCBLCIABAXXX35402984432015-01-31T10:51:34.36Z2015-02-02T06:49:45.49Z1498984PaymentsIC
      2-Feb-152-Feb-150OK150202SCBLCIABXXXX00527183562015-02-02T01:00:21.40Z2015-02-02T06:50:16.83Z1498984TradeIC
      2-Feb-152-Feb-150OK150202SCBLCIABXXXX00527183562015-02-02T01:00:21.40Z2015-02-02T06:50:16.83Z1498984TradeIC
      2-Feb-152-Feb-150OK150202SCBLCIABAXXX35412984522015-02-02T07:28:20.85Z2015-02-02T07:55:08.09Z1498984PaymentsIC
      2-Feb-152-Feb-150OK150202SCBLCIABAXXX35412984482015-02-02T02:06:45.50Z2015-02-02T08:27:46.71Z1415664PaymentsIC
      2-Feb-152-Feb-150ERRIDE150202SCBLCIABAXXX35412984482015-02-02T02:06:45.50Z2015-02-02T08:27:46.71Z1415664PaymentsIC

      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