8 Replies Latest reply on Aug 23, 2018 11:30 PM by Shinichiro Murakami

Tableau Date diff calculation

sunny p Aug 19, 2018 2:13 AM

I am trying to calculate date difference between two date fields based on status flag. "Start time" and "End time" are the two direct fields which depend on "status flag", consists of login, logout and entry. Based on entry, column C and column D calculated (data attached). Now how to calculate difference in time if there is no entry login and entry logout status flag. I need to get difference in minutes. Can some one help me with this.

Workbook.xls 64.0 KB

1. Re: Tableau Date diff calculation

Shinichiro Murakami Aug 19, 2018 9:22 AM (in response to sunny p)

Hi Sunny,

Could you explain how to recognize calculation difference for these two rows?
Also C5-D4= 0, not 40.

Shin
Like Show 0 Likes(0)

Actions
2. Re: Tableau Date diff calculation

sunny p Aug 19, 2018 1:29 PM (in response to Shinichiro Murakami)

Hello Shin,
Sorry, that's typo error. The calculations differences are,

c3-b2 = 2 Min
c4-d3=10 Min
c5-d4=10 Min
C6-d5 = 0 Min
e7-d6=60 Min
Like Show 0 Likes(0)

Actions
3. Re: Tableau Date diff calculation

Shinichiro Murakami Aug 19, 2018 1:53 PM (in response to sunny p)
One more concerns were d5 and c6 were exactly same time.
I needed to modify to add 0.000001 to c6 to recognize the sequence.

From edit data source, pivot data.

You get 82 now.

If you don't like dupulicated rows

Thanks,
Shin

start_end_minutes_SM_10.5.twbx 42.8 KB
Like Show 0 Likes(0)

Actions
4. Re: Tableau Date diff calculation

Shinichiro Murakami Aug 19, 2018 8:30 PM (in response to Shinichiro Murakami)
This should be easier.

Thanks,
Shin

start_end_minutes_SM_10.5_v2.twbx 51.4 KB
Like Show 0 Likes(0)

Actions
5. Re: Tableau Date diff calculation

sunny p Aug 19, 2018 9:25 PM (in response to Shinichiro Murakami)

Thank you so much Shin.Appreciate your help.
Like Show 0 Likes(0)

Actions
6. Re: Tableau Date diff calculation

Shinichiro Murakami Aug 19, 2018 9:49 PM (in response to sunny p)

HI Sunny,

You are welcome.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
7. Re: Tableau Date diff calculation

sunny p Aug 23, 2018 10:51 PM (in response to Shinichiro Murakami)

Hello Shin,

I need to sum up time in difference column related to member name in my data but I am getting negative values and Measure option is greyed out when I did right click on this calculated field. Can you help me how to to Sum of these minutes on a row level related to particular member.
Like Show 0 Likes(0)

Actions
8. Re: Tableau Date diff calculation

Shinichiro Murakami Aug 23, 2018 11:30 PM (in response to sunny p)

I am sorry it's always difficult to discuss the issue without seeing data.
Could you please mock up data and attach twbx file and illustrate the issue and expected results.

Regards,
Shin
Like Show 0 Likes(0)

Actions