<query>
	<title>IPv6</title>
	<category>Browser</category>
	<withpageviews>false</withpageviews>
	<withactions>false</withactions>
	<columns>
		<column>
			<source function="true">CASE "IPVersion" WHEN 4 THEN 'IPv4' WHEN 6 THEN 'IPv6' ELSE 'IPvX' END</source>
			<alias>IPType</alias>
			<title>IP-Version</title>
			<group>1</group>
			<fill>IPv4;IPv6</fill>
		</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>
			<default>0</default>
		</column>
		<column>
			<barsource>SessionsCount</barsource>
			<title></title>
			<width>80</width>
			<percent>true</percent>
			<color>#4cc12f</color>
		</column>
		<column>
			<source function="true">COUNT(DISTINCT "VisitorId")</source>
			<alias>VisitorsCount</alias>
			<title colspan="2">Eindeutige~Besucher</title>
			<align>right</align>
			<total>sum</total>
			<format>%d</format>
			<default>0</default>
		</column>
		<column>
			<barsource>VisitorsCount</barsource>
			<title></title>
			<width>50</width>
			<percent>true</percent>
			<color>#d8b916</color>
		</column>
		<column>
			<source function="true">CAST(COUNT(DISTINCT "SessionId") AS real) / COUNT(DISTINCT "VisitorId")</source>
			<alias>AvgVisits</alias>
			<title>Besuche pro~Besucher</title>
			<format>%.1d</format>
			<align>right</align>
			<default>0</default>
		</column>
	</columns>
</query>
