<query>
	<title>Operating systems</title>
	<withpageviews>false</withpageviews>
	<withactions>false</withactions>
	<columns>
		<column>
			<source function="true">strftime('%Y-%m', "SessionStartTime", 'localtime')</source>
			<alias>Month</alias>
			<title>Monat</title>
			<group>1</group>
			<sort>1</sort>
		</column>
		<column>
			<source>OperatingSystem</source>
		</column>
		<column>
			<source function="true">AVG(CASE t_OperatingSystem."Value" WHEN 'win/nt/xp' THEN 1 ELSE 0 END)</source>
			<alias>WinXPAvg</alias>
			<title colspan="2">Windows XP</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>WinXPAvg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE t_OperatingSystem."Value" WHEN 'win/nt/7' THEN 1 ELSE 0 END)</source>
			<alias>Win7Avg</alias>
			<title colspan="2">Windows 7</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>Win7Avg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE t_OperatingSystem."Value" WHEN 'win/nt/8' THEN 1 WHEN 'win/nt/8.1' THEN 1 ELSE 0 END)</source>
			<alias>Win8Avg</alias>
			<title colspan="2">Windows 8</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>Win8Avg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE t_OperatingSystem."Value" WHEN 'win/nt/10' THEN 1 ELSE 0 END)</source>
			<alias>Win10Avg</alias>
			<title colspan="2">Windows 10</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>Win10Avg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE OSNAME(t_OperatingSystem."Value") WHEN 'Linux' THEN 1 ELSE 0 END)</source>
			<alias>LinuxAvg</alias>
			<title colspan="2">Linux</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>LinuxAvg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE OSNAME(t_OperatingSystem."Value") WHEN 'OSX' THEN 1 ELSE 0 END)</source>
			<alias>OSXAvg</alias>
			<title colspan="2">Mac OS X</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>OSXAvg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE OSNAME(t_OperatingSystem."Value") WHEN 'Android' THEN 1 ELSE 0 END)</source>
			<alias>AndroidAvg</alias>
			<title colspan="2">Android</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>AndroidAvg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE OSNAME(t_OperatingSystem."Value") WHEN 'iOS' THEN 1 ELSE 0 END)</source>
			<alias>iOSAvg</alias>
			<title colspan="2">iOS</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>iOSAvg</barsource>
			<title></title>
			<width>60</width>
			<color>#4cc12f</color>
			<absolute/>
		</column>
	</columns>
</query>
