How can we calculate the Difference and the average between the rows,
You can first use cross tab to convert to horizontal rows then use formula tool datetimediff. Use Summary tool for the average.
Hello @rohit782192,
you could do this by using a multi row formula (it allows you to reference the previous line): it would look like something like this :
DateTimeDiff([Time], [row-1:Time], ‘seconds’)
you can then use a summarize to calculate the average
It give me a Message . Malformed Function call.
Make sure to check on the data type. Use a select tool to verify how it's reading the data. It should be reading it as date time format before using the formula.
