I can see its possible to do a boxplot on data, but for some reason it doesn't like data in the format min:sec.000 (eg 1:35.369)- your examples don't include an example with data in this format
A picture is better than words, so this is what i get - software won't let me do boxplot analysis.
attached the viz - have a go yourself and let me know if you can do a boxplot or not ?
Quali_Laptime_AZE.JPG 108.8 KB
Can anyone else help ?
Apologies in advance if this is what you've already tried.
This may not work out for you,
but just wanted to throw out the idea of using a dual axis
with the second axis being a timedifference is seconds between the q.laptime and
the minimum q.laptime. Then on the new axis you could add the boxplot.
The tooltips aren't quite as useful, but maybe you could engineer them to show
what you want using some the methods described here:
269167boxplot.twbx 1.8 MB
That looks like it would work, only I can't access your file (i updated my workbook with data from the 5th Race),
by trying to access your file somehow managed to delete the workbook from tableau and it won't let me restore it from the .twbx file ..
Hmm. Not sure how to resolve.
Here's what I attempted so that you can recreate in your workbook:
Get the minimum time in the dataset [Minimum Time]:
Get the difference between any point and the minimum [Timediff mininimum (sec)]:
Place [Timediff mininimum (sec)] on the Rows shelf and set it up as a dual axis.
Add the boxplot to that axis and set the mark opacity to 0%.
In the process of recreating the workbook,
thanks for the advice and solving my querry