Hello community, I need to receive the difference of the points in a chart, to use in a calculated field of my project.
Below we have a date field with timestamp, showing the interval for hours
So you want to see the change from one point to the next?
Yes, that's right, the difference between the points, between two points in the case, in a matter of hours
Can you provide a packaged workbook so we can show you how?
Here is my friend, I wanted the difference between hours of each table row for example.
Many thanks for the support!
The following will give you the number of hours difference between the current and previous date. Is this what you're looking for? If so, be sure to compute the table calculation using Dataexample as shown below.
// Difference from previous value.
DATEDIFF('hour', LOOKUP(MAX([Dataexample]),-1), ATTR([Dataexample]))
Jun 19, 2019 8:47 AM