Single chart mode

Series orientation: columns


CategoryJanFebMarAprMayJun
Download12008201100290036003802
Upload89260300120015001100



Series orientation: rows


CategoryJanFebMarAprMayJun
Download12008201100290036003802
Upload89260300120015001100






Combination chart mode



<type>CategoryJanFebMarAprMayJun

Download12008201100290036003802
barUpload89260300120015001100





Confluence content statistic ( From SQL)



select s.spacename,count(case when contenttype='PAGE' then contenttype else null end) as Page, count(case when contenttype='ATTACHMENT' then contenttype else null end) as Attachment from CONTENT c join SPACES s on c.spaceid=s.spaceid JOIN SPACEPERMISSIONS sp ON s.spaceid=sp.spaceid where sp.PERMALLUSERSSUBJECT is null and sp.PERMGROUPNAME is null and sp.PERMUSERNAME is null and c.version=1  group by s.spacename;