Dear all,
I have a chart with calculated dimension which i want to show as pareto however the cumulative is not summing correctly. i have tried to investigate but cant find a solution.
In the dimension i have this expression
=DUAL(
Replace(Class([Time Waiting (hrs)], 3), '<= x <', '-')&' hrs'
,Class([Time Waiting (hrs)], 3))
and in the expression for bars i have this
Count({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX'}, CaseType = {'Emergency'}>}DISTINCT PAT_ID)
the cumulative which is not showing correct has this
RangeSum( Above(Count({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX}, CaseType = {'Emergency'}>}CUST_ID), 0,RowNo()))
/
COUNT({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX}, CaseType = {'Emergency'}>} TOTAL CUST_ID)
