Percentages of Total

[#1]

Good afternoon,

I am trying to get a percentage of the total row.   Take for instance the top row has 300 sent to agent, i want to know what the percentage of 138,889 in total calls this is.  Currently, my expression only states sent to agent/all calls.  I tried to plug the sent to agent/sum(Total([All Calls]) to no avail.  Any help would greatly be appreciated.

Thank you,

Kristy

[erichshiino]

Kristy,

What is your expression to get the 138 889?

If [All Calls] is a field in your model, it should work... What happen when you create only this as an expression (sum TOTAL [All Calls] )

[#3]

All calls is calculated by counting the CallCounter that I have added into the script.  Should my expression be [Sent to agent]/sum(Total CallCounter)?

Thanks

[erichshiino]

Yes,

You can not use the total modifier associated with another expression in the object

Regards,

Erich

[#5]

When I use that expression, the chart comes back up blank. 

[Sent to agent]/sum(Total CallCounter)

Now, Call Counter is a field I added in the script.  Would that be why?  It's not an original field.

[erichshiino · Accepted solution]

What do you get when you make sum(Total CallCounter) as an expression?

Try to replace the [Sent to Agent] by the original sum expression too

[#7]

Thank you!!!  Perfect!!!