script and sql to calculate offset for last x days

diff --git a/gnuplot/calc-offset.sh b/gnuplot/calc-offset.sh
new file mode 100755 (executable)
index 0000000..84133c6
--- /dev/null
+++ b/gnuplot/calc-offset.sh
@@ -0,0 +1,7 @@
+#!/bin/sh
+
+days=90
+test ! -z "$1" && days=$1
+
+cat calc-offset.sql | sed "s/90 days/$days days/" | psql -A -t -F' ' zc 
+

diff --git a/gnuplot/calc-offset.sql b/gnuplot/calc-offset.sql
new file mode 100644 (file)
index 0000000..3df7f50
--- /dev/null
+++ b/gnuplot/calc-offset.sql
@@ -0,0 +1,4 @@
+select pn,-avg(x_axis_angle),-avg(y_axis_angle) from zc
+where time > now() - interval '90 days'
+group by pn
+order by pn ;