ranking the slots
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Preparation
- Time Series
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
[]