
1. Re: Time as Dimension
Ken Flerlage Oct 13, 2019 11:28 AM (in response to Timothy Hong)You'll want to first convert it to seconds by doing a bit of string parsing. Try this calculated field:
Seconds
// Convert time (string) to number of seconds. INT(SPLIT([Time], ":", 1)) * 3600 + INT(SPLIT([Time], ":", 2)) * 60 + INT(SPLIT([Time], ":", 3))
If you want, you can modify that to then convert to hours:
Hours
// Hours [Seconds]/3600

2. Re: Time as Dimension
Michel Caissie Oct 13, 2019 11:33 AM (in response to Timothy Hong)Timothy,
Because you have a discrete dimension on the Rows , Tableau builds a line chart for every discrete value of Time. And since each value appears only once you cant get a line.
First you will need to transform your discrete Time values in Continues values.
You can split your time dimensions using : as a delimiter (in the Dimension pane, rightclick Time and select Transform  Custom split).
You now get three dimensions, one for the hour, one for the minute and one for the seconds.
From this you can compute the hours as a continuous value
(
(INT( [hour] ) * 60 * 60 )
+
(INT( [minute] ) * 60)
+
INT( [second] )
)
/
3600
Next you will have to change the Year value from an Int to a Date using
DATE( STR( [Year] ) +'0101' )
Using this you can get a graph like this
but there is a problem with 1982 because they were probably two competitions in that year and the times are Summed.
I don't know how you want to manage that, but I replaced hours with
{FIXED [Year],[Place],[Gender]: MIN([hours])}
This way the graph will only use the lowest times of the two competitions giving you the following graph.
Michel

3. Re: Time as Dimension
Timothy Hong Oct 13, 2019 3:52 PM (in response to Ken Flerlage)Thank you Ken, it works!