Tickets changed in the last 30 days
GChart(type="pie", chs="500x300", chtt="By Component", query="select component, count(*) from ticket where changetime > extract(EPOCH from (now() - interval '30 days')) 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 '30 days')) 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 '30 days')) group by \"month\" order by \"month\"", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="By Status", query="select status, count(*) from ticket where changetime > extract(EPOCH from (now() - interval '30 days')) group by status", 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 '30 days')) 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 '30 days')) group by version", columns=[('x', 'labels'), ('y', 'scaled')])?
GChart(type="pie", chs="500x300", chtt="By Type", query="select type, count(*) from ticket where changetime > extract(EPOCH from (now() - interval '30 days')) group by type", columns=[('x', 'labels'), ('y', 'scaled')])?
