Problem with Sum - CDEF function

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Problem with Sum - CDEF function

Post by SergioAbe »

Good morning!

I made the follwing CDEF funcion:

Traffic_Out : b,d,f,h,+,+,+,8,*
Traffic In : a,c,e,g,+,+,+,8,*

And see the picture in annex to clarify.

In the MAX item I have b=935.83 M
d=10.60 K
f=210.86 M
h=10.73K

The total should be = 1.15 G, but the Cacti shows 983.96 M.

What is wrong in this case?

The Last (Atual) and Average (Media) the value is correct!!!

Thanks in advance.
Attachments
Graficos CACTI.txt
(290 Bytes) Downloaded 57 times
Cacti Summ.JPG
Cacti Summ.JPG (111.77 KiB) Viewed 2656 times
BenGonGon
Posts: 19
Joined: Mon Aug 29, 2011 3:03 pm

Re: Problem with Sum - CDEF function

Post by BenGonGon »

not sure but have you try this ?
Traffic_Out : b,d,+,f,+,h,+,8,*
Traffic In : a,c,+,e,+,g,+,8,*
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

BenGonGon,

I will try this sugestion!

Thanks!
BenGonGon
Posts: 19
Joined: Mon Aug 29, 2011 3:03 pm

Re: Problem with Sum - CDEF function

Post by BenGonGon »

tell me if that's work
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

OK!
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

BenGonGon

I have the same results with initial formula.
BenGonGon
Posts: 19
Joined: Mon Aug 29, 2011 3:03 pm

Re: Problem with Sum - CDEF function

Post by BenGonGon »

how have you construct your graph and addition ?
User avatar
camerabob
Cacti User
Posts: 386
Joined: Fri Feb 10, 2017 2:45 pm
Location: Long Island, New York, USA
Contact:

Re: Problem with Sum - CDEF function

Post by camerabob »

Why the *8 at the end?
Prod: Cacti 1.2.15 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

BenGonGon

Yes. I construct de graphics. The result of sum is the same value.
Attachments
Formula.JPG
Formula.JPG (32.26 KiB) Viewed 1803 times
Parametros.JPG
Parametros.JPG (133.21 KiB) Viewed 1803 times
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

camerabob

*8 to convert bytes in bits.
BenGonGon
Posts: 19
Joined: Mon Aug 29, 2011 3:03 pm

Re: Problem with Sum - CDEF function

Post by BenGonGon »

Hello,
it is possible to show me this please ?
Sans titre.png
Sans titre.png (139.76 KiB) Viewed 1722 times
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

Good morning.
Attachments
TOTAL SUM.jpg
TOTAL SUM.jpg (399.2 KiB) Viewed 1630 times
BenGonGon
Posts: 19
Joined: Mon Aug 29, 2011 3:03 pm

Re: Problem with Sum - CDEF function

Post by BenGonGon »

Hello,
it is normal cdefed ?
Sans titre.png
Sans titre.png (845.21 KiB) Viewed 1574 times
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

BenGonGon

Yes, I separate the lines of In and Out.
SergioAbe
Posts: 18
Joined: Wed Aug 08, 2018 8:39 am

Re: Problem with Sum - CDEF function

Post by SergioAbe »

The sum of Average and Last are correct value.

The problem is only in MAX!.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests