1 Reply Latest reply on Jan 3, 2019 2:33 PM by Patrick Van Der Hyde

How to caculate TimeDiff for 2 rows for each Value

Shivam Agrawal Nov 28, 2018 2:41 AM

Hello All,

I know there is a lot of solution available for the similar kind of problem and i tried most of them but seems like none of them is working in my case.

My Problem:

I want to create a Calculated Field TimeDiff which hold the TimeDiff for ( First Occurance Time for NEWVALUE = 602 ) and ( First Occurance Time for NEWVALUE = 202) for each NUMBER.

1. Re: How to caculate TimeDiff for 2 rows for each Value

Patrick Van Der Hyde Jan 3, 2019 2:33 PM (in response to Shivam Agrawal)

Hello Shivam,

Did you locate a solution to this issue? If you could share a small bit of data in a packaged workbook, this appears to be fairly straight forward use of creating two new fields based upon the value of [NewValue] field for each [Number] and then using a view that does not include the New Value field so you then are able to utilize a datediff() function for the two new fields.

Please share a packaged workbook - Packaged workbooks: when, why, how

Thank you

Patrick
Like Show 0 Likes(0)

Actions

Tableau Community Forums

How to caculate TimeDiff for 2 rows for each Value

1. Re: How to caculate TimeDiff for 2 rows for each Value

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account