Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
SEGMENT | DISK | DATA_TS | SEEK TIME |
---|---|---|---|
1 | $FC0101 | 10/01/2012 | 28 |
1 | $FC0244 | 10/02/2012 | 32 |
2 | $FC2100 | 10/01/2012 | 19 |
3 | $FC3200 | 10/03/2012 | 30 |
3 | $FC0140 | 10/01/2012 | 34 |
3 | $FC0140 | 10/02/2012 | 28 |
3 | $FC0140 | 10/03/2012 | 33 |
3 | $FC0140 | 10/04/2012 | 35 |
7 | $FC0101 | 10/02/2012 | 44 |
7 | $FC2301 | 10/05/2012 | 20 |
I would like a result table that looks like this:
SEGMENT | DISK | DAYS OVER THRESHOLD |
---|---|---|
1 | $FC0244 | 1 |
3 | $FC3200 | 1 |
3 | $FC0140 | 3 |
7 | $FC0101 | 1 |
try: sum(if([Seek Time] >= vThreshold,1,0))
or maybe count({$<[Seek Time]={'>=$(vThreshold)'} >} Disk)
could u post how u're calculating Days over threshold using thershold value of 30 for each segment.
mention something abt seek time
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.
Do you want to calculate this in the script or a chart?
-Rob
In a Chart.
Thanks,
Lew
try: sum(if([Seek Time] >= vThreshold,1,0))
or maybe count({$<[Seek Time]={'>=$(vThreshold)'} >} Disk)
Gysbert,
Most appreciated, the first expression did the trick!
Best Regards,
Lew