Thanks you for the tip Shawn. The correct file is attached. (I think.)
David, first let me welcome you to the forums! And thank you for posting a packaged workbook. Also thanks for helping us refine our "common mistakes" document. Unfortunately I have to refer you back to this (newly edited) document, paying close attention to #2, item 2. Sorry.
EDIT: Hang on. I just clicked cancel for that password request, got a Tableau error, and then the workbook loaded anyway anyway, with an extract. Hmmm, what's that all about Dimitri Blyumin? David, now that I can open your workbook, I'll take a look.
One way to solve this is to use a table calculation, like this:
ATTR([DateTime]) - LOOKUP(ATTR([DateTime]),-1)
it must be partitioned to compute using DateTime.
Same approach can be used for createTime. See attached workbook for a solution.
Shawn, I have no idea what that login pop-up was. I also got it, and my guess is that for some reason SQL Server connections still prompt for password, even though extract is being used. Oracle doesn't do that for me.
TimingExample DB edit.twbx.zip 345.0 KB
Thanks so much for the help.