I have a load script that loads data with a timestamp into a qvd and gives me a table of data with multiple records per unique Primary Key with the timestamps. The load happens multiple times a day.
The base data looks like this:
Team
VolumeOfCalls
TimepStamp
A
15
22/01/2018 15:00
B
9
22/01/2018 15:00
C
20
22/01/2018 15:00
A
20
22/01/2018 17:00
B
10
22/01/2018 17:00
C
25
22/01/2018 17:00
A
20
23/01/2018 15:00
B
10
23/01/2018 15:00
C
25
23/01/2018 15:00
A
25
23/01/2018 17:00
B
15
23/01/2018 17:00
C
30
23/01/2018 17:00
I want to report daily volumes at the end of each day like below:
Sum of VolumeOfCalls
TimepStamp
Team
22/01/2018
23/01/2018
Grand Total
A
20
25
45
B
10
15
25
C
25
30
55
Grand Total
55
70
125
Any pointers on how to achieve this as I'm struggling. I need to be able to identify the max timpestamp for each day and only report off that.
