In SQL you can do a window function to get the value of the previous row and do a calculation while partitioning the data by another column.
All I'm trying to do is get the date value of the previous row and find the difference. Then at an aggregate level, take the average.
Can you do this in tableau as well?
Please find below example from tableau sample data source
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...