Increment seconds on date/time

Question

I have the need to increment the seconds on a date/time field if an ID is the same.  An example of the data would include

IDDATE/TIME32015-06-03 00:00:0032015-06-03 00:00:0052014-01-15 00:00:0052014-01-15 00:00:0052014-01-15 00:00:00

The end result I'm looking for is...

IDDATE/TIME32015-06-03 00:00:0032015-06-03 00:00:0152014-01-15 00:00:0052014-01-15 00:00:0152014-01-15 00:00:02

I figured I would use the multi-row tool where I could group by the ID and then use an expression to add the increment.  However I cannot figure out the format of the expression I should use.

Thableaus · Accepted Answer

Hi @G_WOLAK

You could use the Tile Tool for that.

Tile Tool with Unique Method on ID.

Use Formula Tool to add the seconds - DateTimeAdd([DATE/TIME],[Tile_SequenceNum] - 1, "seconds")

WF attached.

Cheers,

Jonathan-Sherman · Accepted Answer

Hi @G_WOLAK,

Just to show you there is also always more than one way to solve a problem this is the multi row formula route you were talking about taking. I've attached the workbook for you to download if needed.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan