<query>
	<title>Browser nach Monat</title>
	<category>Browser</category>
	<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>Browser</source>
		</column>
		<column>
			<source function="true">AVG(CASE BROWSERNAME(t_Browser."Value") WHEN 'Firefox' THEN 1 ELSE 0 END)</source>
			<alias>FirefoxAvg</alias>
			<title colspan="2">Firefox</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>FirefoxAvg</barsource>
			<title></title>
			<width>80</width>
			<color>#e88200</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE BROWSERNAME(t_Browser."Value") WHEN 'Chrome' THEN 1 ELSE 0 END)</source>
			<alias>ChromeAvg</alias>
			<title colspan="2">Chrome</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>ChromeAvg</barsource>
			<title></title>
			<width>80</width>
			<color>#00c000</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE BROWSERNAME(t_Browser."Value") WHEN 'Internet Explorer' THEN 1 ELSE 0 END)</source>
			<alias>IEAvg</alias>
			<title colspan="2">Internet Explorer</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>IEAvg</barsource>
			<title></title>
			<width>80</width>
			<color>#0064ff</color>
			<absolute/>
		</column>
		<column>
			<source function="true">AVG(CASE BROWSERNAME(t_Browser."Value") WHEN 'Opera' THEN 1 ELSE 0 END)</source>
			<alias>OperaAvg</alias>
			<title colspan="2">Opera</title>
			<align>right</align>
			<format>%.1p</format>
		</column>
		<column>
			<barsource>OperaAvg</barsource>
			<title></title>
			<width>80</width>
			<color>#d80000</color>
			<absolute/>
		</column>
	</columns>
</query>
