ETL Aggregation Issues

[izai]

We have 2 timeprofiles defined, 1 hour & 30 minutes aggregation.
However values in table R_1_STAT_RES (30 mins) were lesser than table R_2_STAT_RES(1 hour)

Anyone has any ideas what is the problem ?

[cavagnaro]

Can you please be more clear? How are the jobs configured? What are those tables? Stats definitions? Logs? Lesser how?

[tony]

I think they mean that, when you add up 2 x 30 mins, the Totals are less than the 1 x 1 hour...

If I had a penny for every time that someone asked that... 

izai - is that the problem?

Tony

[izai]

when we generate report using these 2 tables,
for example, we got:
1 hour table  : N_Inbound = 339,Total talk time = 03:34:17
30 mins table : N_Inbound = 182,Total talk time = 02:00:22

[cavagnaro]

Is it me or I don't see nothing wrong here?
Hehe Tony, that is a common question for, how was it? lewsers? hehe

[izai]

actually the figures were total for one whole day, it should tally at the end of the day, am i right ?

[cavagnaro]

Sorry but don't get it.

[GenesysNewbie]

ummm  i d like 2 help, but dont understand the problem.   

[ecki]

Hi Izai,

Could you please post the whole extract from both tables for only one object and spanning through two whole days? Put the extract in to excel spreadsheet.

Cheers,

ecki.

[izai]

Attached are requested data from both tables.. hope anyone can help me..

[cavagnaro]

Can you also post the definition of your stats and if they are TotalNumber or TotalNumberAdjusted / Action or Status? My guess is that your definition is as Action so you are watching the info in this way. Meaning, the stat is only counted when the event finished and not while occuring in the time profile selected.

[ecki]

I see the error you are doing. You are comparing two different time spans. In the hour table your time span is from 2pm to 11pm where as in the subhour table the time span is from 2pm to 6:30pm. If you summarized the exact time span from both tables, you would get correct numbers.

Cheers,

ecki.

[izai]

yes you were right, let me check few things here again..
thanks

[izai]

cavagnaro : here are the sample of our stat definition

[TotalNumberInboundCalls]
Category=TotalNumber
Description=Total inbound call
Formula=DCID
MainMask=CallInbound, HandlingInbound
Objects=Agent, GroupAgents, GroupPlaces, Place, RegDN
Subject=DNAction

[Total_Calls]
Category=TotalAdjustedNumber
Description=Total number of times agent completed handling a call
Formula=DCID
MainMask=CallUnknown, CallConsult, CallInternal, HandlingInternal, CallOutbound, HandlingOutbound, CallInbound, HandlingInbound, ASM_Outbound
Objects=Agent, GroupAgents, GroupPlaces, Place
Subject=AgentStatus

anything went wrong ?

[cavagnaro]

ecki is right, doing the sum in the correct time span it does sum ok.