Tickets not changed in the last 100 days
GChart(type="pie", chs="500x300", chtt="By Component", query="select component, count(*) from ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by component order by component", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="By Owner", query="select owner, count(*) from ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by owner", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="Creation Month", query="SELECT to_char(date_trunc('month', TIMESTAMP WITH TIME ZONE 'epoch' + time * INTERVAL '1 second'), 'YYYY - MM (Month)') as \"month\", count(id) FROM ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by \"month\" order by \"month\"", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="Last Change Month", query="SELECT to_char(date_trunc('month', TIMESTAMP WITH TIME ZONE 'epoch' + changetime * INTERVAL '1 second'), 'YYYY - MM (Month)') as \"month\", count(id) FROM ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by \"month\" order by \"month\"", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="By Priority", query="select priority, count(*) from ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by priority", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="By Version", query="select version, count(*) from ticket where changetime < extract(EPOCH from (now() - interval '100 days')) and not status = 'closed' group by version", columns=[('x', 'labels'), ('y', 'scaled')])?
