ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Rounding and Times

Jon_Taylor
8 - Asteroid

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

 

Jon_Taylor_0-1614698524716.png

 

Thanks,

Jon

AngelosPachis
15 - Aurora

Hi @Jon_Taylor ,

 

Regarding the second issue, I assume that be saying rounding the 3 digit column to 2 digits you mean rounding 337 to 340 or 866 to 870, right?

 

If that's the case you can use a round function, as show below

 

Round([3 digits column],10)

 

AngelosPachis_0-1614700016035.png

 

Concerning issue 1, I'm not sure what you are trying to do. What kind of analysis you are after?

 

Cheers,

 

Angelos

Jon_Taylor
8 - Asteroid

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.

 

Also my workflow is in progress of being built 🙂

 

pedrodrfaria
13 - Pulsar

Hi @Jon_Taylor 

 

I believe the example below should help you fix the round issue:

 

pedrodrfaria_0-1614705434514.png

 

I attached the workflow.

 

Pedro.

 

MarqueeCrew
19 - Altair
19 - Altair

@Jon_Taylor ,

 

I assume that you know that:

 

min("1:12:123","1:12:124") returns the smaller

 

 you can sort or use min function or summarize min and get the fastest time. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Jon_Taylor
8 - Asteroid

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. 

 

Thanks again!

MarqueeCrew
19 - Altair
19 - Altair

The summarize tool allows you to find the min out fastest time across many rows.  

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels