Graphite

Multi columns printing

Asked by Francisco Perea

Hi,

After searching for hours how to setup X-Axis I still have a question
I'm working with energy efficency. We take measures from energy
consumption and production at the same time. As an example say:

Month Energy Production
   [KWh] [Ton]
march-98 138480 2161680
april-98 122880 2103370
may-98 155280 2401320
jun-98 157920 2537565
jul-98 159600 2303359
aug-98 177600 2811775

An so on. The interesting graph in this time series is Energy vs.
Production. Is possible to graph this with graphite? By default X-Axis is
always fixed to time series, but I need to change that to Production and
setup Y-Axis to Energy. How could I do this?

Thanks in advance

Question information

Language:
English Edit question
Status:
Solved
For:
Graphite Edit question
Assignee:
No assignee Edit question
Solved by:
chrismd
Solved:
Last query:
Last reply:
Revision history for this message
Best chrismd (chrismd) said : 		#1

Graphite doesn't support non-timeseries plots currently. You can plot some function of energy and production over time, but the x-axis can only represent time.

If you need Graphite for storage purposes but its graphing doesn't meet your needs you can use its API to extract the raw data and render it elsewhere. Just add '&format=raw' (or csv, json, etc) to get the data. This type of thing is easy to do with matplotlib and I've had a long neglected todo to implement easy integration between scipy/matplotlib and graphite. Let me know if you'd be interested in taking a stab at this.

Revision history for this message
Francisco Perea (fapeream) said : 		#2

Thanks chrismd, that solved my question.

Revision history for this message
Francisco Perea (fapeream) said : 		#3

Thanks for your answer.

I'm really interested in finding a nice solution for a "more generic" RRD database + graph tool, but I don't know too much about phyton, neither scipy/matplotlib about.
So I'll be reading something about them and then try. By the way, have you any good / easy material /tutorial to learn?
I was searching and also found a solution with jpgraph, but with PHP. Problem is PHP hasn't a Round Robin Database yet (I think).

Best regards

Francisco Perea

Revision history for this message
Francisco Perea (fapeream) said : 		#4

Thanks for your answer.

I'm really interested in finding a nice solution for a "more generic" RRD
database + graph tool, but I don't know too much about phyton, neither
scipy/matplotlib about.
So I'll be reading something about them and then try. By the way, have you
any good / easy material /tutorial to learn?
I was searching and also found a solution with jpgraph, but with PHP.
Problem is PHP hasn't a Round Robin Database yet (I think).

Best regards

Francisco Perea

2011/10/17 chrismd <email address hidden>

> Your question #175000 on Graphite changed:
> https://answers.launchpad.net/graphite/+question/175000
>
> Status: Open => Answered
>
> chrismd proposed the following answer:
> Graphite doesn't support non-timeseries plots currently. You can plot
> some function of energy and production over time, but the x-axis can
> only represent time.
>
> If you need Graphite for storage purposes but its graphing doesn't meet
> your needs you can use its API to extract the raw data and render it
> elsewhere. Just add '&format=raw' (or csv, json, etc) to get the data.
> This type of thing is easy to do with matplotlib and I've had a long
> neglected todo to implement easy integration between scipy/matplotlib
> and graphite. Let me know if you'd be interested in taking a stab at
> this.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
>
> https://answers.launchpad.net/graphite/+question/175000/+confirm?answer_id=0
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/graphite/+question/175000
>
> You received this question notification because you asked the question.
>