Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Call Logged date | Reason for CallNo. of Calls | % | |
01/06/2015 | Reason 12 | 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
use below expression for % values
sum(callcounter)/sum(TOTAL callcounter).
now you can get % wise values.