Grouping and ranking data question

TMonty0319

Hi. I have minute level data i am dealing with. I am trying to get total minutes that a post is open during a day. It can be post 1, post 2, or no activity. I am grouping by Date (Day) and Post then doing a difference between then Max and min timestamp to get total minute sin the post.

This is how I want my data output to come out:

Post	Min timestamp	Max timestamp	Minutes (Max Time - Min Time)
Post 1 open	2024-07-28 9:00am	2024-07-28 9:30am	30
No Activity	2024-07-28 9:31am	2024-07-28 10:31am	60
Post 2 open	2024-07-28 10:32am	2024-07-28 1:32pm	180
Post 1 open	2024-07-28 2:00pm	2024-07-28 3:00pm	60

Instead it comes out like this

Post	Min timestamp	Max timestamp	Minutes (Max Time - Min Time)
Post 1 open	2024-07-28 9:00am	2024-07-28 3:00pm	360
No Activity	2024-07-28 9:31am	2024-07-28 10:31am	60
Post 2 open	2024-07-28 10:32am	2024-07-28 1:32pm	180

Is there a way to to a rank function or something? I want to group by post but i cant figure out how to group the time correctly. Thanks!

MichelleH

@TMonty0319 What does your original data look like?