Above Function

[mphekin12]

Hello,

I'm trying to show build the chart below using a straight table and thought it would be an easy Above() call.

I cannot seem to get the 'Time of Row Above' column to calculate correctly.  This is what I currently have:

Can anyone help me with this issue?

Thank you!

[harsh44_bhatia]

Hello,

Assuming that for each CT.CASE_NUMBER and CASE_TIMES_TYPE your dataset has unique CASE_TIMES_DT_TM. then use the following

code first expression as =Only(CASE_TIMES_DT_TM)

second Expression= Above(total aggr(Only(CASE_TIMES_DT_TM),CT.CASE_NUMBER,CASE_TIMES_TYPE )   ,1)

if you have multiple timestamp for Case_Number & Case_TIMES_TYPE then use aggregation function in the first expression, something like max(CASE_TIMES_DT_TM)