DES/Statistik

aktive Bearbeiter pro Woche

select week(date_created) +1 as week, count( distinct uid) from entry where id >= 9000000  group by week;

Gnuplot-Skript:

set title "Aktive Bearbeiter pro Woche"
set xlabel "Kalenderwoche"
set ylabel "Anzahl"
set yrange [0:
plot 'bearbeiter.txt' with lines lw 2 notitle