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!

[sunny_talwar]

Would you be able to share your application (sample)?

[mphekin12]

Sorry Sunny but there is data in the application that I cannot share.  All of the data is coming from one table.  I just need a way to show the date/time from the row above, then the difference between the current row date/time and the date/time from the row above it. 

[Clever_Anjos · Accepted solution]

If you have more than one dimension try using Above (Total yourexpression)

[sunny_talwar]

What is your expression? Hopefully you have a TOTAL qualifier since you are dealing with multiple dimensions in your chart

I would think something along these lines:

Sum(Time) - Above(TOTAL Sum(Time))

[sathishkumar_go]

Hi,

Just try above(CASE_TIMES_DT_TM).

Post your application with sample data.

-Sathish

[mphekin12]

Thank you Clever!  That worked perfectly.

[mphekin12]

Sathish,

Thanks for your reply but I tried that and it didn't work.  Using Above (Total your expression) as Clever suggested worked for me.

[mphekin12]

Sunny,

I didn't have a TOTAL qualifier.  That seemed to do the trick.

Thank you for your help!

[sunny_talwar]

Not a problem, glad we were able to help