replace two sensors in bakaceva

[zc] / gnuplot / by_day.sql

diff --git a/gnuplot/by_day.sql b/gnuplot/by_day.sql
index f138f63..2ee08bd 100644 (file)
--- a/gnuplot/by_day.sql
+++ b/gnuplot/by_day.sql
@@ -1,7 +1,7 @@
 select 
 to_char(min(time), 'YYYY-MM-DD HH24') as time,
 avg(x_axis_angle) ,
-avg(y_axis_angle) - ( ( 20 - avg(sensor_temperature) ) * 0.0001 ),
+avg(y_axis_angle) - ( ( (select avg(sensor_temperature) from zc where pn = 2008050087) - avg(sensor_temperature) ) * 0.0001 ),
 avg(sensor_temperature) 
 from zc
 where pn = 2008050087 -- and time > now() - interval '24 hours'