Aggregator Grouping
Posted: Thu Sep 16, 2004 2:53 am
I am trying to aggregate some data from a source file containing records of telephone calls made on a certain day. When I pass the data into the aggregator, I want to group by the following fields in this order:
Date, Site, Call Application Number, Quarter Hour Slot, Half Hour Slot.
It seems to work fine with Date and Site but the problems begin with Call Application Number. It works so far in that all Applications beginning with a 1 come before any beginning with a 2. However, within all the ones beginning with a 1, there is no order to them. In other words, 110 may come before 1 and if there are multiple instances of the same number, they are not always grouped together. Is this because the Aggregator only looks at the first digit and if so, how can I change it to check the entire record before doing the grouping ?
Following in on from that, I have a CALL_OFFD column which needs to be totalled for each Quarter Hour, for each Application for each Site on the specified day. So therefore there should be 96 rows for each day (1 row for each Quarter hour slot during the day). I would assume therefore that if I SUM this column that would do the trick, but it doesn't. Not sure if this is the SUM function that isn't working or whether it is down to the Grouping not working.
Any suggestions ?
Date, Site, Call Application Number, Quarter Hour Slot, Half Hour Slot.
It seems to work fine with Date and Site but the problems begin with Call Application Number. It works so far in that all Applications beginning with a 1 come before any beginning with a 2. However, within all the ones beginning with a 1, there is no order to them. In other words, 110 may come before 1 and if there are multiple instances of the same number, they are not always grouped together. Is this because the Aggregator only looks at the first digit and if so, how can I change it to check the entire record before doing the grouping ?
Following in on from that, I have a CALL_OFFD column which needs to be totalled for each Quarter Hour, for each Application for each Site on the specified day. So therefore there should be 96 rows for each day (1 row for each Quarter hour slot during the day). I would assume therefore that if I SUM this column that would do the trick, but it doesn't. Not sure if this is the SUM function that isn't working or whether it is down to the Grouping not working.
Any suggestions ?