Sum other values than Bandwidth
Moderators: Developers, Moderators
Sum other values than Bandwidth
Hi,
i want to sum incoming and outgoin Messages from my Exim Mailserver. The graph shows all values correct. But when I add a Total Line with |sum:0:current:0:auto| the result is not what I expect Can anybody help me?
i want to sum incoming and outgoin Messages from my Exim Mailserver. The graph shows all values correct. But when I add a Total Line with |sum:0:current:0:auto| the result is not what I expect Can anybody help me?
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Please be more specific. There is a CDEF called "Total of All Data Sources". You should consider that.
TheWitness
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Ok, i will try
I have a graph for my exim. In this Graph are 2 Data-Sources, Inbound and Outbound Messages. It will be nice to have that i can have a total value for each Data-Source.
Inbound Current: Average: Maximum: Total:
Same for outbound. And after that a total sum for both with the CDEF Function "Total all Data Sources"
Is it possible?
Regards
Tom
I have a graph for my exim. In this Graph are 2 Data-Sources, Inbound and Outbound Messages. It will be nice to have that i can have a total value for each Data-Source.
Inbound Current: Average: Maximum: Total:
Same for outbound. And after that a total sum for both with the CDEF Function "Total all Data Sources"
Is it possible?
Regards
Tom
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Sorry, quite confused at the moment at your inquirey.
TheWitness
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
sorry for confusing you
I 've attached my Graph. As you can see there are 2 Datasources Inbound and Outbound. Now i want to have a sum for all Inbound and all Outbound Messages, the value for Total In and Total out ist not really correct
regards
Tom
I 've attached my Graph. As you can see there are 2 Datasources Inbound and Outbound. Now i want to have a sum for all Inbound and all Outbound Messages, the value for Total In and Total out ist not really correct
regards
Tom
- Attachments
-
- graph_image.php.png (7.49 KiB) Viewed 5713 times
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
Tom,
I the example, what should Total In and Total Out be? I am still a bit confused.
Larry
I the example, what should Total In and Total Out be? I am still a bit confused.
Larry
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
So, you want it for the time period select the total of all values. This would be equivalent to Average * Number of Samples? Is this what you want.
AKA. If your selected time period is 30 minutes and your sample rate was 5 minutes and the average was 20 samples per interval, your total would be 120?
TheWitness
AKA. If your selected time period is 30 minutes and your sample rate was 5 minutes and the average was 20 samples per interval, your total would be 120?
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
- TheWitness
- Developer
- Posts: 17007
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
The problem is determining the timespan when there are so many options. This is a feature request to expose the timespan and number of samples as a replacement value for application in a CDEF although there are many other methods that I may not be aware of.
TheWitness
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Tom,rebel wrote:okay, i understand. Thx for your time and help.
Tom
I fiddled around with the |sum: ...| feature a bit just to solve a similar problem with a mail scanning probe (spamassassin). My base value is the value for "the scanned mails of the last 60 sec." and I tried to sum up as |sum:auto:current:2:auto| which is nearly the same as your approach (only different formatting). I ended up with sums that are exactly 60 times the value that is to be expected (that is: average * 60 minutes per hour * 24 hours per day). But I don't know how to do maths with this |sum: ...| values. I'd like to put them in a CDEF like "|sum: ...|,60,/". Or to have a CDEF that totals all values of the currently displayed graph (but I don't know how).
Still searching ...
Reinhard
Currently, there is no way to apply mathematical manipulations to the summation value. This value is calculated outside of RRDtool by Cacti and therefore cannot be manipulated using a CDEF. I suppose it would be possible to add something like this in the future... I'd have to think about it a bit though.
-Ian
-Ian
- gandalf
- Developer
- Posts: 22383
- Joined: Thu Dec 02, 2004 2:46 am
- Location: Muenster, Germany
- Contact:
Ian,
just tried another workaround. I added a GPRINT to my graphs based on the values to be summed up. Then I applied a CDEF (in this case: devide by 60 as in the example above), based on the LAST value, the math is correct. Now I changed this graph template item from GPRINT to COMMENT and introduced the text format "Total: |sum:auto:current:2:auto|". But this does not sum up the CDEFed values, sigh!
So my question is: may it be easier to |sum:...| CDEFed values than adding maths to the |sum:...| feature?
with thanx for your work
Reinhard
just tried another workaround. I added a GPRINT to my graphs based on the values to be summed up. Then I applied a CDEF (in this case: devide by 60 as in the example above), based on the LAST value, the math is correct. Now I changed this graph template item from GPRINT to COMMENT and introduced the text format "Total: |sum:auto:current:2:auto|". But this does not sum up the CDEFed values, sigh!
So my question is: may it be easier to |sum:...| CDEFed values than adding maths to the |sum:...| feature?
with thanx for your work
Reinhard
Unfortunately, no. Cacti only has access to the raw values that are stored in the .rrd files. RRDtool does not apply CDEF's until the graph is actually generated, which is outside of Cacti's influence.lvm wrote:So my question is: may it be easier to |sum:...| CDEFed values than adding maths to the |sum:...| feature?
-Ian
Who is online
Users browsing this forum: No registered users and 1 guest