I am trying to figure out a way to calculate the number of days an item has been flagged as over a specific threshold.
To be more specific SEGMENT is made up of multiple disks, each DISK will have different values over a selected time frame. Lets say my timeframe is 5 days and vThreshold = 30 -- data may look something like this:
Days over threshold is to be calculated by counting the number of days where SEEK TIME >=30, i.e. how many days does a specific DISK show up with a SEEK TIME >= 30 over a select DATA_TS range. Hope this helps.