Hi, Having a doubt, TimeBucket2019-08-03 13:11:2310-202019-08-03 13:10:0410-202019-08-03 13:10:000-102019-08-03 13:09:340-102019-08-03 13:08:120-10 How to divide data in this format?

ranking the slots

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?

Transformation

Preparation

Time Series

Accepted answers

NickSm

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

TimeBucket.yxmd

All comments

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

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

TimeBucket.yxmd

geraldo

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

[]

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703