Chart question...

[#1]

Another chart question I'm afraid (I will master these)

I've used the Straight Table chart option to create a chart which contains two dimensions... IndexDate and CallsReason.  The expressions are =sum(CallCounter) which gives me the number of calls and I'd like to include another which details the % of these calls.  Should I be creating a Calculated Dimension? The table below is similar to the one I've created.

Reason for CallReason 1

Header 1	Header 2	Header 3	Header 4
Call Logged date	No. of Calls	%
01/06/2015	2	0%
01/06/2015	Reason 2	11	0%
01/06/2015	Reason 3	8	0%
02/06/2015	Reason 1	10	0%
02/06/2015	Reason 2	5	0%

Thanks in advance

[Anonymous]

Use a calculated dimension for % of calls. can you also please share your data?

[arulsettu]

add another expression

sum(CallCounter)/sum(Total CallCounter)

[swuehl]

Try the TOTAL qualifier:

For percentage share per Date:

=sum(CallCounter) / sum(TOTAL<IndexDate> CallCounter)

Or for total share:

=sum(CallCounter) / sum(TOTAL CallCounter)

[#5]

another expression:

%calls= sum(callcounter)/sum(Total(callcounter)

or sum(callcounter) check relative , u will get percentages.

[#6]

Hi Melanie,

It sounds more like you should add a new expression and maybe move over to a pivot table and pivor it so you get the header dim the way you liked (vertical).

Good luck!

[Anonymous]

You can simply use the same expression again and tick the "relative" option

[tracysmart · Accepted solution]

Melanie

you can add a second expression (which will be the same as the first one sum(CallCounter) and select the Relative checkbox, this should then give you the number of calls as a percentage of the total instead of the absolute number

[Anonymous]

Hi

try this.

Regards.

/Giuseppe

[#10]

Thanks Tracy... the expression already existed, I just needed to check the 'Relative' box. Thanks so much for the prompt replies.