Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im trying to chart the percentage of timeliness cumulative by for the current month by day, I tried the formula below with no success.
=aggr(rangesum(above((sum([ddweeklytimeliness.AllAppTimely])/sum([ddweeklytimeliness.AllAppTotal]),0,rowno()))),[ddweeklytimeliness.dispdate])
Thank you.
Check this
=Sum(aggr(rangesum(above((sum([ddweeklytimeliness.AllAppTimely])/sum([ddweeklytimeliness.AllAppTotal]),0,rowno(TOTAL)))),[ddweeklytimeliness.dispdate]))
Thank you for your response but it didn't work.
Your title shows different than your context. so difficult to find. Can you explain little more?
Im trying to show a graph, as follows. Nov 1t timeliness 98%, Nov 2 97%, Nov 3 99%, the data for Nov 3 would include Nov 1-3, not individual days.