Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
If you have more than one dimension try using Above (Total yourexpression)
Would you be able to share your application (sample)?
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.
If you have more than one dimension try using Above (Total yourexpression)
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))
Hi,
Just try above(CASE_TIMES_DT_TM).
Post your application with sample data.
-Sathish
Thank you Clever! That worked perfectly.
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.
Sunny,
I didn't have a TOTAL qualifier. That seemed to do the trick.
Thank you for your help!
Not a problem, glad we were able to help