This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am stuck on something that seems like it would be easy. I have looked around the community and web a few days to get an example or guidance but I still seem to not find and answer.
I have a multi issue problem here, so lets start with the first issue. I have a list of race times listed as xx:xx:xxx. I have come across multiple sources of information stating that Alteryx can not process that time format. For racing data the milliseconds could be the determination of a win or loss. I have my data input in the format of x.xx.xxx and my first Idea was to separate the numbers for minuets, seconds, milliseconds. I thought then rounding the milliseconds to "2" digits and then put the string back together in the time format of xx:xx:xx would a good start. Once I have that I planned to use the "date & time" parser to start getting into a form i can analyze.
This lead to my new issue of trying to Round the 3 digit column to 2 digits. After looking I can not find any guides on this.
If you have a link or idea please in regards to rounding or my overall issue with times please reply. any information is appreciated
Thank you for your input. In regards to rounding I am trying to make it so the 3erd digit is rounded and I am left with just 2 digits. I want to do this because Alteryx can not handle the time format of xx:xx:XXX. the accuracy will be off due to this but I think if I round the milliseconds I can then use an Alteryx format. Below is what I wanted to achieve. I believe your formula can be used and I can just remove the last digit. I have also included my flow for more clarity.
:333 to :33
:336 to :34
So a time of 1:00:333 and 1:00:336 can be differentiated to show who was fastest.
Thank you for the ideas, I will attempt to use the Min() formula which I actually did not know about to try and see if I can get the sorting done. I guess my only concern would be it looks like you are adding all times in the formula to be sorted. can I use Min([race time]) to get the min of the column? I am excited to get into playing around with this as well as see what I can do now that the time is in a format that Alteryx can parse. I am not sure if that will even do anything but we will see.