Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
here are the example (accumulation) I was talking about.
The other lines, objects are some experiments.
Rainer
if anyone got some spare time 🙂
Amien,
it seems it takes a while get it to work.
Rainer
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
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>
Amien,
here are the example (accumulation) I was talking about.
The other lines, objects are some experiments.
Rainer
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
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
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