percentage calculation

[buzzy996]

hi,

my dimensions are

1.Name

2. calculated dimension is "=If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>=6,'SLAs Not Met','SLAs Met')"

and expression is--> =Count(IP_No__c) ,So I'm getting the below screen results.

Expected values/output are: Instituted of numbers I need percentages for example first dimension in above chart shows "73,754 and 1784" for the same expected out is "97.63% and 2.36%"

any help?

thanks

[sunny_talwar]

Have you tried selecting relative?

[ali_hijazi]

Count(IP_No__c) / count(Total IP_No__c)

[jagan]

HI,

Try like this

=Count(IP_No__c) / Count(TOTAL IP_No__c)

Or select relative option.

Regards,

Jagan.

[buzzy996]

hi Sunny/Jagan,

i tried both by applying Relative or ount(IP_No__c) / Count(TOTAL IP_No__c) geting the belwo result.

the problem with above chart is the percentages are calculating with respect to all the dimensions("corp,nphoe....,ent AG,mhope" equalizes to 100%),my case each dimension is equalizes to 100%(for example the first dimension corp is one dimension combination of sla met & not met)

any help?

thanks

[jonathandienst · Accepted solution]

Qualify the total with Name, like this

Count(IP_No__c) / count(Total <Name> IP_No__c)

[Digvijay_Singh]

Your legend is showing some error, could you see why its showing error? You didn't mention in problem so I thought may be missed in checking that.

[buzzy996]

Thanks Jonathan.

Thank you all

[avinashelite]

if you want the total according to one of the dimension values ...then use the TOTAL key word along with the expression

like count(ID)/count(distinct TOTAL<dimension1>ID)

[buzzy996]

hi guys,

i 've to include avg line by considering only sla met cases.

can help some one?

thanks