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 ?
??? Can you please be more clear? How are the jobs configured? What are those tables? Stats definitions? Logs? Lesser how?
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
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
1 Like
??? Is it me or I don’t see nothing wrong here?
Hehe Tony, that is a common question for, how was it? lewsers? hehe
actually the figures were total for one whole day, it should tally at the end of the day, am i right ?
Sorry but don’t get it.
ummm i d like 2 help, but dont understand the problem. ???
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.
Attached are requested data from both tables.. hope anyone can help me..
1 Like
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.
1 Like
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.
yes you were right, let me check few things here again..
thanks
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 ?
ecki is right, doing the sum in the correct time span it does sum ok.
sorry everyone, i’ve wrongly extract from the other centre which the problem was caused by the filter in hyperion.
The attached should be the right data extract from the problematic site.
That looks like as the data come from completely different planets. Could you pls export both report layouts from DMA in to xml files and post it here?
e.
Secondly, it looks like the 30 minutes report layout has some troubles. It is very strange that the intervals 10:00 and 1:30 has zeros in each stats except logging time. As the Stat server would lose connection to TServers for the whole collection interval. How does look like the CCA topology? Is the data from first table collected by the same Data sourcer as the data from second table?
Did you mean, Layout Templates? Coz I can’t export Report Layout, the Export menu is disabled.
Attached is .zip contains 4 layout templates in .xml. FYI, our x-developer has created 4 layout templates in our DMA.
How should I know, which currenty is being used? All in active
only one Data Sourcer for this site.
1 Like