sum over sum question (sample included)

[amien]

If someone could help me out .. that would really be great,

i have this code in an expression. in dimension i have a user and a team.

in a new expression i want the sum of the sum, based on team level.

cause there are more users in a team, the value will be the same for each user within the team.

Thanks in advanced

(sum(calls) / sum(TOTAL <user> calls))
*
(sum(total <user> duration)+sum(total <user> talktime))

[amien]

if anyone got some spare time 🙂

[#3]

Amien,

it seems it takes a while get it to work.

Rainer

[#4]

Hi Amien,

not able to upload an example at the moment. I can provide an accumulation by team.

Not exactly what you want but a step forward.

RangeSum(User, Above(Team))

Name your columns and use the expression above as example.

Another idea is to calculate some figures during load in the script (Sum, Group By).

And hopfully then are calculations are easier by expressions in an object.

Rainer

[amien]

thanks for your reply . .but not working .. let me try to simplfy

see. attachment

user,team,expression

expression:

(sum(calls) / sum(TOTAL <user> calls))
*
(sum(total <user> duration)+sum(total <user> talktime))
<pre>
these values show the values i need
now i want to remove the user dimension.
when i do that, the expression doesnt show the right values. The sum on team level is not working.
tried to add <team,user> instead of <user> but isnt correct too
 </body>

[#6 · Accepted solution]

Amien,

here are the example (accumulation) I was talking about.

The other lines, objects are some experiments.

Rainer

[amien]

in your 'accumulation i was talking about'

team1,user 1 shows 924,44

but

team1, user 3 shows 4571,11

while both should show 4571,11

[amien]

i will simplify my question.

see screenshot:

dimensions: user, team

expression:

sum(calls) / sum(TOTAL <user> calls))
*
(sum(duration)+sum(talktime))

this is all correct. Now i want to delete the user dimension. Result will be that the expression will be summed. But this not correctly summed

See attachment in first post.

load script cant be altered .. i'm looking for an expression solution

[amien]

Rainer

I could make this with using the load script, but looking for an expression.

going to make a new thread and be more specific.

Thanks for your time