my dimensions are
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%"
Solved! Go to Solution.
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)
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.
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)