Hi All,
I create a trendline, highlighting the minimum and maximum across time using the following expressions.
Trendline:
(SUM({<EndDt>} ConditionCnt)/SUM({<EndDt>} MemberMonths)*12)*1000
Minimum Dot:
if(rank(-(SUM({<EndDt>} ConditionCnt)/SUM({<EndDt>} MemberMonths)*12))=1,(SUM({<EndDt>} ConditionCnt)/SUM({<EndDt>} MemberMonths)*12)*1000)
Maximum Dot:
if(rank((SUM({<EndDt>} ConditionCnt)/SUM({<EndDt>} MemberMonths)*12))=1,(SUM({<EndDt>} ConditionCnt)/SUM({<EndDt>} MemberMonths)*12)*1000)
I'd like to be able to calculate the median across time to put into a text box. How would I calculate this? I can calculate the median for the end date selected using:
MEDIAN(((ConditionCnt/MemberMonths)*12)*1000)
However I can't do the following because nested aggregation is not allowed in this function:.
MEDIAN((SUM({<EndDt>} IPASCCHFCnt)/SUM({<EndDt>} MemberMonths)*12)*1000)
Any workaround? Thanks!!