Subtract values based on specific criteria

I'm in a pinch and attempting to get myself through a formula to figure out the differences of two columns, based on specific criteria. This is an audit table, and each item has it's own row every time the item is updated.

I'm looking to create two columns, to get two different values but it has to be based on the status. Here is the columns I'm using:

 https://imgur.com/a/qCNVdzA

What I would like is to be able to subtract:

1. BatchCount when: TrackingIds are the same, AuditReason=Other, RemovalTeamId=7 or 8, and UpdatedBy is = checkin for one value and audit by the second value.

2. UpdateDate when: TrackingIds are the same and UpdatedBy is checkout for one value and checkin for the other value.

Thank you!

So you can only do datediff like this on columns.  So what you will likely need to do is pivot that data on the Updated by, so that you would have a column for checkin and Audit, the easy as that you can just datediff the checkin and audit columns

**Note, you may need to setup a dataset without those other columns that could be different as they as they would separate your rows.

I am having similar trouble as a new BI user. I'm trying to calculate session length that is dependent on the variables "action" and "user" or "ip address" to capture distinct sessions. I've tried a few different things but am not having much luck.

Based on this sample data (below) I'd expect that session length calc would result in the following results:

Expected Results:

Sample data

need to isolate distinct users/sessions and then subtract time where action = logout vs login.

greatly appreciate any ideas.