trying to get a report of rules triggered by week then in a weeku5. date format having issues. ignore "week" column cant seem to get variations of group by and of Week(time_stamp) and other ways to work? need some help. Obs app_id procs_date rule_id time_stamp decision_tp_c week12345678910 10917558 01JAN2021:00:02:30.457 CRNSF 09FEB2021:00:16:41.813 DECLN 1001341 10917558 01JAN2021:00:02:30.457 HATNF 05FEB2021:00:17:30.287 DECLN 1001341 10917558 01JAN2021:00:02:30.457 EMAILAGE 05FEB2021:00:17:31.163 DECLN 1001341 10917559 01JAN2021:00:03:01.437 NODEP 06FEB2021:00:16:24.983 DECLN 1001341 10917560 01JAN2021:00:07:05.450 NODEP 06FEB2021:00:16:24.797 DECLN 1001341 10917561 01JAN2021:00:09:42.347 NODEP 06FEB2021:00:16:24.610 DECLN 1001341 10917562 01JAN2021:00:15:01.203 CRNSF 15JAN2021:00:17:36.520 DECLN 1001341 10917562 01JAN2021:00:15:01.203 HATNF 01JAN2021:00:15:08.920 DECLN 1001341 10917562 01JAN2021:00:15:01.203 DUPADD 01JAN2021:00:15:10.453 DECLN 1001341 10917563 01JAN2021:00:16:44.987 EMAILAGE 01JAN2021:00:16:52.377 DECLN 1001341
... View more