-
1. Re: Adjust how time stamps are displayed
Sharad Adhikari Jun 21, 2016 11:00 AM (in response to philip.thornton)Hi Philip,
Please find the tbwx file attached. I intentionally added one more column called Event. You should have something like this right.
Then I used LOD to find out Min time and date as well as Max time and date for each event. Once done I calculated the time consumed.
Let me know if you have any question.
BR
Sharad
-
2. Re: Adjust how time stamps are displayed
philip.thornton Jun 21, 2016 12:00 PM (in response to Sharad Adhikari)I'm unable to open your attachment. The error says the file was created by a newer version of Tableau and I need to upgrade if I want to open it up. I'm running Tableau 9.2.9 and don't have time to upgrade to Tableau 3.x at the moment.
Philip
-
3. Re: Adjust how time stamps are displayed
Sharad Adhikari Jun 21, 2016 12:52 PM (in response to philip.thornton)Hi,
Let me explain.
1. Add a column called Event and give different names to event. I gave A to E.
2. Create Max time calculated field. { FIXED [Event]:MAX([Time])}
3. Create Min time calculated field. { FIXED [Event]:MIN([Time])}
4. Calculate time consumed for each event. DATEPART('minute', [Max time])-DATEPART('minute', [Min time])
5. Final output should be like this.
Best of luck.
BR
Sharad
-
4. Re: Adjust how time stamps are displayed
philip.thornton Jun 21, 2016 2:04 PM (in response to Sharad Adhikari)Manually giving names to the start of each set would work however I have thousands of rows that will be extracted daily. Manually adjusting isn't an option.
I need some sort of logic that does something like this...
IF DATEADD("minute",1,CURRENT(timestamp)) <> NEXT(timestamp) THEN assign group name.
The part I'm hung up on is dynamically assigning each group their "name" so I can then determine how long each set lasted. I'll continue to play with it in hopes I find a way to get it done.
Philip