I would like the occurrences of an item sale within 60 seconds by a Geographic location as well as the Total of those items sold. Note: Item 1 and 2 do have the same DateTime. Data: GeoLoc ItemNum DateTime Price Miami 1 2019-05-24 09:21:55.000 2.00 Miami 2 2019-05-24 09:21:55.000 2.49 Miami 3 2019-05-24 09:22:30.000 .99 Miami 4 2019-05-24 09:28:55.000 .49 Dallas 5 2019-05-24 10:05:13.000 2.50 Dallas 6 2019-05-24 10:08:42.000 4.00 Dallas 7 2019-05-24 10:10:05.000 7.00 Dallas 8 2019-05-24 10:10:56.000 3.99 Dallas 9 2019-05-24 10:11:02.000 .89 Desired Result GeoLoc DateTime Volume TotalPrice Miami 2019-05-24 09:21:55.000 1 2.00 Miami 2019-05-24 09:21:55.000 2 4.49 Miami 2019-05-24 09:22:30.000 3 5.48 Miami 2019-05-24 09:23:27.000 2 1.48 Dallas 2019-05-24 09:23:13.000 1 2.50 Dallas 2019-05-24 09:23:42.000 2 6.50 Dallas 2019-05-24 09:26:05.000 1 7.00 Dallas 2019-05-24 09:26:56.000 2 10.99 Dallas 2019-05-24 09:27:02.000 3 11.88 I tried using intnx as well as a slew of other methods, including inner joins and datediffs, but I can't seem to get the results that I'm looking for. Thank you in advance!
... View more