Thrshold configuration for advanced ping template for links

[mryogi]

I wish to configure threshold for advanced ping template-packet loss, used for monitoring WAN link statistics.

I am not getting here, what value to be used in thold-template so that threshold alarm will be fired.
when packet loss for link exceeds 3 to 5 % in certain time.

To get some idea, I exported the packet loss graph data to excel. In this graph Why is that showing "NaN" and some places "inf" instead of showing some finite value?

OR what value I need to use in thold template so that alarm will be fired?

requesting somebody to guide me.




col5-e 1-2% 3-5% 6-10% 11-15% 16-50% 51-95% 96-100% col13-b
3.49E+00 NaN NaN NaN NaN NaN NaN NaN 7.40E+01
1.21E+00 NaN NaN NaN NaN NaN NaN NaN 7.32E+01
8.07E+00 NaN NaN NaN NaN NaN NaN NaN 7.51E+01
2.25E+00 NaN NaN NaN NaN NaN NaN NaN 7.33E+01
3.50E+00 NaN inf NaN NaN NaN NaN NaN 7.39E+01
1.20E+00 inf NaN NaN NaN NaN NaN NaN 7.46E+01
6.65E-02 NaN NaN NaN NaN NaN inf NaN 7.46E+01
NaN NaN NaN NaN NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN NaN NaN NaN NaN
NaN NaN NaN NaN NaN NaN NaN NaN NaN
======================================================================
It seems that this "inf" might be showing from below code. if yes, from where I can get details of this code as which value will be shown for any condition?

I checked this link: http://oss.oetiker.ch/rrdtool/doc/rrdgraph_data.en.html
but I am not able to get exact details required here.

CDEF:cdefg=d,0,GT,d,2,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefh=d,3,GT,d,5,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefi=d,5,GT,d,10,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefj=d,10,GT,d,15,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefba=d,15,GT,d,50,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefbb=d,50,GT,d,95,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefbc=d,95,GT,d,100,GT,UNKN,INF,IF,UNKN,IF \
CDEF:cdefbd=d,UN,1,EQ,TIME,300,+,NOW,GT,UNKN,INF,IF,d,95,GT,INF,UNKN,IF,IF \
CDEF:cdefbf=e,2,/ \
CDEF:cdefbh=c,b,-,e,-,3,/ \
CDEF:cdefcd=d,0,GT,d,2,GT,UNKN,b,IF,UNKN,IF \
CDEF:cdefce=d,3,GT,d,5,GT,UNKN,b,IF,UNKN,IF \
CDEF:cdefcf=d,5,GT,d,10,GT,UNKN,b,IF,UNKN,IF \
CDEF:cdefcg=d,10,GT,d,15,GT,UNKN,b,IF,UNKN,IF \
CDEF:cdefch=d,15,GT,d,50,GT,b,INF,IF,UNKN,IF \
CDEF:cdefci=d,50,GT,d,95,GT,UNKN,b,IF,UNKN,IF \
CDEF:cdefcj=d,95,GT,d,100,GT,UNKN,b,IF,UNKN,IF \

=====================================================================
Information of my cacti server:

Date Sun, 18 Dec 2011 10:54:52 +0530
Cacti Version 0.8.7g
Cacti OS unix (Ubuntu Desktop 10.04 lucid)
SNMP Version NET-SNMP version: 5.4.2.1
RRDTool Version RRDTool 1.3.x
Hosts 79
Graphs 279
Data Sources Script/Command: 81
SNMP: 87
SNMP Query: 84
Script - Script Server (PHP): 34
Total: 286
Poller Information
Interval 300
Type spine
Items Action[0]: 255
Action[1]: 81
Action[2]: 34
Total: 370
Concurrent Processes 1
Max Threads 1
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:58.5216 Method:spine Processes:1 Threads:1 Hosts:80 HostsPerProcess:80 DataSources:370 RRDsProcessed:271
PHP Information
PHP Version 5.3.2-1ubuntu4.10
PHP OS Linux
PHP uname Linux Virtualbox 2.6.32-36-generic #79-Ubuntu SMP Tue Nov 8 22:29:26 UTC 2011 i686
PHP SNMP Installed
max_execution_time 30
memory_limit 512M
MySQL Table Information

[gandalf]

Moving to THOLD forum
R.

[TheWitness]

Please use the RPN Expression data manipulation in THold and setup a valid RPN expression if you need to. If you are not at 0.4.9-3 yet, please update.

[Hanseat]

This worked for me getting Alerts for NaNs: http://forums.cacti.net/viewtopic.php?p=251781#p251781