Stack valuates together to a daily bar

> Hi
>
> I am monitoring a solar panel. Every minute the watts are written into a
> the database. Now for better presentation I am trying to gather the
> data’s from every day and present the result for each day in only one
> bar, so I can see for example 7 bars in one week and can se what was the
> best day.
>
> I am working with php and my string is looking like this:
>
>  
>
> /usr/bin/rrdtool graph /var/www/temperature/solarleistung_week.png -s
> -1week DEF:w1=/var/log/digitemp_rrd/solar_kw.rrd:watt:AVERAGE
> LINE1:w1#48d1cc:"Solarleistung in Watt" -h300 -w500 -y1:2 --color
> GRID#dddddd --color MGRID#aaaaaa.
>
> http://152.143.90.130/temperature/solarleistung_week.png
>
>  
>
> How can I say to rrd to gather the data’s every day to one bar?
>
> Regards
>
> Marc
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> rrd-users mailing list
> rrd-users@...
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

> -----Original Message-----
> From: rrd-users-bounces@... [mailto:rrd-users-bounces@...] On
> Behalf Of Bart Van Der Meerssche
> Sent: Thursday, 11 June 2009 8:00 p.m.
> To: Marc Tobien
> Cc: rrd-users@...
> Subject: Re: [rrd-users] Stack valuates together to a daily bar
>
> Hi Marc,
>
> you can achieve this by creating multiple RRA's in one RRD, e.g.
> rrd create ... -s 60
> RRA:AVERAGE:0.5:1:120
> RRA:AVERAGE:0.5:15:192
> RRA:AVERAGE:0.5:1440:60
> RRA:AVERAGE:0.5:10080:520
>
> will store
> 120 entries with a 1min interval
> 192 entries with a 15min interval
> 60 entries with a 1day interval
> 520 entries with a 1week interval
> for you.
>
> Then run:
> rrdgraph ... -s -1week ...
>
> RRD will select the highest resolution available that covers the entire
> interval to plot on the graph. In this case, it will fetch data from the
> 1day RRA.
>
> To see this code in action for my home electricity usage, surf to
> www.flukso.net
>
> Cheers,
> Bart.
>
> Marc Tobien wrote:
> > Hi
> >
> > I am monitoring a solar panel. Every minute the watts are written into a
> > the database. Now for better presentation I am trying to gather the
> > data's from every day and present the result for each day in only one
> > bar, so I can see for example 7 bars in one week and can se what was the
> > best day.
> >
> > I am working with php and my string is looking like this:
> >
> >
> >
> > /usr/bin/rrdtool graph /var/www/temperature/solarleistung_week.png -s
> > -1week DEF:w1=/var/log/digitemp_rrd/solar_kw.rrd:watt:AVERAGE
> > LINE1:w1#48d1cc:"Solarleistung in Watt" -h300 -w500 -y1:2 --color
> > GRID#dddddd --color MGRID#aaaaaa.
> >
> > http://152.143.90.130/temperature/solarleistung_week.png
> >
> >
> >
> > How can I say to rrd to gather the data's every day to one bar?
> >
> > Regards
> >
> > Marc
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > rrd-users mailing list
> > rrd-users@...
> > https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
>
> _______________________________________________
> rrd-users mailing list
> rrd-users@...
> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users

> Hi Bart,
>
> That home electricity graph is so cool!
>
> What I want to know is, how do you collect the data in the first place?!
>
> Cheers,
>
> Mark
>
>> -----Original Message-----
>> From: rrd-users-bounces@... [mailto:rrd-users-bounces@...] On
>> Behalf Of Bart Van Der Meerssche
>> Sent: Thursday, 11 June 2009 8:00 p.m.
>> To: Marc Tobien
>> Cc: rrd-users@...
>> Subject: Re: [rrd-users] Stack valuates together to a daily bar
>>
>> Hi Marc,
>>
>> you can achieve this by creating multiple RRA's in one RRD, e.g.
>> rrd create ... -s 60
>> RRA:AVERAGE:0.5:1:120
>> RRA:AVERAGE:0.5:15:192
>> RRA:AVERAGE:0.5:1440:60
>> RRA:AVERAGE:0.5:10080:520
>>
>> will store
>> 120 entries with a 1min interval
>> 192 entries with a 15min interval
>> 60 entries with a 1day interval
>> 520 entries with a 1week interval
>> for you.
>>
>> Then run:
>> rrdgraph ... -s -1week ...
>>
>> RRD will select the highest resolution available that covers the entire
>> interval to plot on the graph. In this case, it will fetch data from the
>> 1day RRA.
>>
>> To see this code in action for my home electricity usage, surf to
>> www.flukso.net
>>
>> Cheers,
>> Bart.
>>
>> Marc Tobien wrote:
>>> Hi
>>>
>>> I am monitoring a solar panel. Every minute the watts are written into a
>>> the database. Now for better presentation I am trying to gather the
>>> data's from every day and present the result for each day in only one
>>> bar, so I can see for example 7 bars in one week and can se what was the
>>> best day.
>>>
>>> I am working with php and my string is looking like this:
>>>
>>>
>>>
>>> /usr/bin/rrdtool graph /var/www/temperature/solarleistung_week.png -s
>>> -1week DEF:w1=/var/log/digitemp_rrd/solar_kw.rrd:watt:AVERAGE
>>> LINE1:w1#48d1cc:"Solarleistung in Watt" -h300 -w500 -y1:2 --color
>>> GRID#dddddd --color MGRID#aaaaaa.
>>>
>>> http://152.143.90.130/temperature/solarleistung_week.png
>>>
>>>
>>>
>>> How can I say to rrd to gather the data's every day to one bar?
>>>
>>> Regards
>>>
>>> Marc
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> rrd-users mailing list
>>> rrd-users@...
>>> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
>> _______________________________________________
>> rrd-users mailing list
>> rrd-users@...
>> https://lists.oetiker.ch/cgi-bin/listinfo/rrd-users
> Notice of confidential information:
> The information contained in this e-mail message is
> confidential information and may also be legally privileged,
> intended only for the individual or entity named above.  
> If you are not the intended recipient you are hereby
> notified that any use, review, dissemination, distribution
> or copying of this document is strictly prohibited.
> If you have received this document in error, please
> immediately notify the sender by telephone and destroy the
> message. Thank you.
>
> Any pricing quoted in this email is exclusive of GST and freight
> and is only valid while stocks are available at the quoted price.
>