-
1. Re: Tableau Date diff calculation
Shinichiro MurakamiAug 19, 2018 9:22 AM (in response to sunny p)
-
2. Re: Tableau Date diff calculation
sunny p Aug 19, 2018 1:29 PM (in response to Shinichiro Murakami) -
3. Re: Tableau Date diff calculation
Shinichiro MurakamiAug 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
-
-
4. Re: Tableau Date diff calculation
Shinichiro MurakamiAug 19, 2018 8:30 PM (in response to Shinichiro Murakami)
-
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.
-
6. Re: Tableau Date diff calculation
Shinichiro MurakamiAug 19, 2018 9:49 PM (in response to sunny p)
HI Sunny,
You are welcome.
Thanks,
Shin
-
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.
-
8. Re: Tableau Date diff calculation
Shinichiro MurakamiAug 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