<query>
	<title>Search engines</title>
	<withpageviews>true</withpageviews>
	<withactions>false</withactions>
	<columns>
		<column>
			<source>SearchEngine</source>
			<title>Such-~maschine</title>
			<null>(keine Suchmaschine)</null>
			<group>1</group>
			<sort>2</sort>
		</column>
		<column>
			<source function="true">COUNT(DISTINCT "SessionId")</source>
			<alias>SessionsCount</alias>
			<title colspan="2">Besuche</title>
			<sort dir="desc">1</sort>
			<format>%d</format>
			<align>right</align>
			<total>sum</total>
		</column>
		<column>
			<barsource>SessionsCount</barsource>
			<title></title>
			<width>80</width>
			<color>#4cc12f</color>
			<percent>true</percent>
		</column>
		<column>
			<source function="true">COUNT(*)</source>
			<alias>PageviewsCount</alias>
			<title>Seiten-~aufrufe</title>
			<format>%d</format>
			<align>right</align>
			<total>sum</total>
		</column>
		<column>
			<source function="true">ROUND(CAST(COUNT(*) AS real) / COUNT(DISTINCT "SessionId"), 2)</source>
			<alias>PageviewsPerSession</alias>
			<title>Seitenaufrufe~pro Besuch</title>
			<format>%.2d</format>
			<align>right</align>
			<total>avg</total>
		</column>
		<column>
			<source function="true">SUM("ActivityTimespan") / COUNT(DISTINCT "SessionId")</source>
			<alias>AvgActivity</alias>
			<title colspan="2">Durchschnittliche~Besuchsdauer</title>
			<align>right</align>
			<format>%m:%2e</format>
			<null>(unbekannt)</null>
			<total>avg</total>
		</column>
		<column>
			<barsource>AvgActivity</barsource>
			<title></title>
			<width>50</width>
			<color>#b85ec2</color>
		</column>
		<column>
			<source function="true">SUM("ActivityTimespan")</source>
			<alias>SumActivity</alias>
			<title>Gesamte~Besuchszeit</title>
			<align>right</align>
			<format>%h:%2i:%2e</format>
			<null>(unbekannt)</null>
			<total>sum</total>
		</column>
	</columns>
</query>
