Folks,
I have the following and I'm trying to see what it the best way to establish PCT calculation for Success and Failure by turning
the Query - Automatic Group and Summary Off since this option causes major slowness.
yes. using the total in Aggr. Func. did the trick thanks for Paul's recommendations, but now, I am trying to see what's best for the percentages.
Currently, I have
when [BUSINESS_VIEW].[SuccessUserCertRequest].[TARGET]
='home-phone-number' then
[BUSINESS_VIEW].[SuccessUserCertRequest].[HomePhoneFailureCount]/[Total_All]*100
with Aggreg. Func set to Total. I'm getting weird results.
Action || Success || Success% || Failure || Failure % || Total
'home-phone-number' 2 5 7
What is the best setting to calculate the Success% or Failure %.
That is all I need.
Thx so much for your time.