How to create a graph of daily data totals for an interface?

[ianc911]

Hi folks,

I'm a total noob with Cacti, and I'm trying to create a graph on Cacti 1.2.24 running on Windows\IIS which will show daily total inbound & outbound bandwidth (in GB) for an interface on our firewall. I'm envisioning something like this:

Traffic total.png (12.16 KiB) Viewed 684 times

Each bar would represent one day. I've already created a graph using the "Interface - Traffic (bits/sec, BW)" template, and the totals are being correctly displayed as text, so I need to somehow get this data for a 24 hour period and graph it. I've searched here and seen people ask this question a number of times but not found any answers or directions I can head in. I've browsed through the manual, especially the sections on CDEF's, variables, and in particular bandwidth summation.

I took a stab at creating a graph template, and I figured if I could create a graph from it, I could tweak the template until it began to do what I want it to, but I can't even create a graph with it! For the graph type, if I choose "SNMP Interface Statistics', the template I've created doesn't appear in the 'Select a graph type to create' dialog. If I choose "Graph template based", I can choose my template, but when I click 'Create' next to it, it throws up this dialog, which I've no idea how to complete:

create graph.png (12.48 KiB) Viewed 684 times

Can anyone point me in the right direction or offer suggestions where to look for more information on this specific case? Thanks for any help!

[Osiris]

So, you just need a cdef that multiplies the rate by 86400.

[ianc911]

Hi Osiris, thanks for the reply!

I tried creating another template for the graph using just traffic_out as a data source, and associated it with the SNMP interface statistics data query type. Based on your advice above, I created a new CDEF for the graph which both multiplies the output by 86400, and divides it by a billion (converts bytes to GB). This should give the output in GB\day. I'm still missing something though, because I don't understand the mechanism whereby the data is summed only once per day to give the total traffic for a 24 hour period and only one bar is dislplayed on the graph per 24 hour period. Right now the graph output looks like this:

Traffic total.png (240.86 KiB) Viewed 453 times

As expected, the x axis is still subdivided into three hour periods, and the totals displayed don't make any sense when compared with the text total in the legend at bottom. Any clues on how to go about fixing this? Do I need to create a new data profile with a 24 hour collection period or something? Thanks again for your help!

[Osiris]

It you only want the daily aggregation, simply setup your data source profile to have one row per day, and update the row continually throughout it, or have only a few updates in one day and only keep the first RRA for one day and then one entry for each day thereafter.