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?
Solved! Go to Solution.
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.
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))