Hi!
Let me apologize for the vague title but the one thing that i'm looking for I don't even know if it has a technical name -which limits my ability to google it-.
I have a file with 22.000 rows and these are the headers for each column:
SERIAL NUMBER LOCATION_MONITORING LEVEL EFFECTIVE DATE EXPIRATION DATE
It basically registers when an unit's monitoring level changes and it includes when starts and when it ends.
I'm trying to get a way to be able to determine in any given date how many units where on each monitoring level.
Any ideas on how to do this? Thanks in advance!!
Let me apologize for the vague title but the one thing that i'm looking for I don't even know if it has a technical name -which limits my ability to google it-.
I have a file with 22.000 rows and these are the headers for each column:
SERIAL NUMBER LOCATION_MONITORING LEVEL EFFECTIVE DATE EXPIRATION DATE
It basically registers when an unit's monitoring level changes and it includes when starts and when it ends.
I'm trying to get a way to be able to determine in any given date how many units where on each monitoring level.
Any ideas on how to do this? Thanks in advance!!