Calculate number of days over threshold

[#1]

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

[#2]

could u post how u're calculating Days over threshold using thershold value of 30 for each segment.

mention something abt seek time

[#3]

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.

[rwunderlich]

Do you want to calculate this in the script or a chart?

-Rob

[#5]

In a Chart. 

Thanks,

Lew

[Gysbert_Wassenaar · Accepted solution]

try: sum(if([Seek Time] >= vThreshold,1,0))

or maybe count({$<[Seek Time]={'>=$(vThreshold)'} >} Disk)

[#7]

Gysbert,  

Most appreciated, the first expression did the trick!  

Best Regards,

Lew