ranking the slots

[AlterCom]

Hi, 

Having a doubt, 

Time	Bucket
2019-08-03 13:11:23	10-20
2019-08-03 13:10:04	10-20
2019-08-03 13:10:00	0-10
2019-08-03 13:09:34	0-10
2019-08-03 13:08:12	0-10

How to divide data in this format?

[estherb47]

Hi @AlterCom 

How are you trying to divide the data?

If you're trying to divide the bucket into low and high, then a Text to Columns tool will work. Set the tool to parse on the Bucket field, and use a hyphen as the delimiter to separate into 2 columns.

You can rename them with a Select tool.

Let me know if that helps.

Cheers!

Esther

[NickSm · Accepted solution]

Hi @AlterCom 

My take here is that you're getting a timestamp and looking to bucket the minutes into 0-10, 10-20, 20-30, etc but feel free to add more detail if there's more to it.

Can do this with a formula and an If statement.

Quick sample attached

[geraldo]

Hi

Or this formula too

if DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 10 then '00-10'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 20 then '10-20'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 30 then '20-30'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 40 then '30-40'
elseif DateTimeMinutes([Time]) + (DateTimeSeconds([Time])/100) <= 50 then '40-50'
else '50-00'
endif

[]