Agreggating router interfaces into one graph - plus total

[Linegod]

I've had no issue creating a graph containing multiple device data sources (I was going to post to this topic - http://forums.cacti.net/viewtopic.php?t=5698 , but decided not to ) - see pics.

What I would like now is to add a legend total for the three sources. Is there currently a way to do this?

Selecting 'Total All Data Souces' as a CDEF, would, I assume, only total the input from the selected data source, not all of them on the graph.

[Linegod]

OK, it would appear that creating a new CDEF and using 'Special Data Source: SIMILAR_DATA_SOURCES_NODUPS' and multiplying by 8 (bytes to bits) gives me what I want.

[mait]

hey,

can you explain to a dummy how exactly did you do that?

Mait

[Linegod]

1. Create a new CDEF - Management/Graph Management/CDEFs:
- Click 'Add'
- Create as per the 2nd image above

2. Create a new Graph - Management/Graph Management:
- Click 'Turn Off Graph Debug Mode'
- Click 'Add'
- Leave 'Selected Graph Template' and 'Host' as 'None'
- Click 'create'
- Give your graph a destinctive title and click 'create'
- Add the first data source by clicking 'Add' beside 'Graph Items'
- select your first data source
- select your colour
- in 'Graph Item Type' select 'Area'
- in 'CDEF Function' select 'Bytes into bits'
- give the data source a title
- Click 'create'
- Click 'add' again and create a legend (all values the same as above, except 'Graph Item Type' is 'Legend')
- Add your second data source exactly at the first except 'Graph Item Type' is 'Stack'
- add legend for second data source as above
- Continue adding sources in the same fashion until you are done.

To get the total on the graph, add another Graph Item:
- use the same data source as your last data source
- select your colour
- in 'Graph Item Type' select 'Line 3' (use Line 2 or Line 1 for smaller lines)
- in 'CDEF Function' select 'Total All Data Sources and Bytes into Bits' (the one you created at the start)
- In Text Format, call it 'Total'.
- Click 'create'
- Click 'add' again and create a legend (all values the same as above, except 'Graph Item Type' is 'Legend')

Now you should have a graph with the output from different data sources, plus a total at the bottom.

I created these steps as I made a graph, so it should work

[moya]

Just like you said it...it does work.

Thanks a mill

-Cesar

[d3cypher]

I found this to be very helpful, I've followed it to the letter and it appears the "Total' line is working but the GPRINT info is showing me the last data souce information. Any ideas?

John

[Linegod]

Did you do this one:

- in 'CDEF Function' select 'Total All Data Sources and Bytes into Bits' (the one you created at the start)

[mrgenius]

hi!

ok it help me to create the graph i wanted ... but i did it through hit n trial.... i wanna know logic behind it.

like the CDEF u created applied bits into bytes function.. whats the need of it?? when u are already selecting CDEF of "bytes into bits" for every indiviual datasource??

wat i understood is that when u create new cdef you are have actually created a variable to hold data from indiviual sources like;

NEW-CDEF = datasource1+datasource2+datasource3+so on

Check my attached graph.. which i created with the way you described. I used same CDEF for outbound traffic too.. and i really didn't understand how it worked??

when i select that created CDEF again for outbound traffic.. did it created new instance(new variable) of that CDEF??

can u plzz explain it mathematically?? bcos while creating graphs for users statistics with same way.. its giving wrong answer... for user stats i created CDEF and select only "ALl Similar datasources no duplicates" and it didn't work.

[sohailb]

Hey man I just wanted to say that your instructions rock. I have been looking for a step by step for this exact thing all day. I tried a number of different ones and this is the one that worked exactly as you have described. Thanks a ton.

-sohailb

[Science]

My problem is that my total is totaly f*ck up.. need any help i can get.


Nice tutorial btw. Almost worked [/img]

[Linegod]

My problem is that my total is totaly f*ck up.. need any help i can get.

Looks like you missed adding the legends. Try that, and see if it works.

[Frodoger]

Hello,

can someone help us (mrgenius and me) ???



greetings
Frodoger

[Science]

Iv almost got it to work as i want.


1, I Want my legends to be aligned so its looks good.
2, I dont think that the the graphs are totaly correct. I want "Total" to be the sum of Inbound and Outbound (Its the legends that we are talking about.)

Happy for any help.

[Linegod]

Iv almost got it to work as i want.


1, I Want my legends to be aligned so its looks good.

Try selecting 'Auto Padding' and also making sure you have hard returns on the end of each Legend group.

2, I dont think that the the graphs are totaly correct. I want "Total" to be the sum of Inbound and Outbound (Its the legends that we are talking about.)

I've found that order is very important when doing aggregate graphs. Try as per the directions, with Total at the bottom.

[rony]

Also, to get the padding to work right, and if you are using RRDTool 1.2.x, you need to be using a fix width font. Otherwise, there is really no easy way to calculate how far to space it over.

Btw, the default font is fix width.