The ‘test’ value is a calculated field - ‘percentOfTotal(count(fraudmethodchild),[{Impact Framework - Other}])’ - with Impact Framework - Other being a nested calculated field - ‘distinct_countIf(caseid,contains({Impact Framework},“Other”))’
If this is the use case, then we can calculate the denominator and then write another calculated field to find the distribution %.
Step 1: calculate Numerator (this is already done by you)
Step 2: calculate denominator - Total case with impact framework other
totalcase = distinctcountover(ifelse(impact framework=‘Other’,caseid, null),,pre_Agg)
Step 3: find ratio from numerator and denominator
%total = count / avg(totalcase)
Hi @hopeah,
It’s been awhile since we last heard from you, were you able to find a work around or are you still in need of further assistance? If so, creating a sample analysis in the Arena view like Prantika mentioned would be helpful!
If we do not hear back within the next 3 business days, I’ll close out this topic.