Paste P6598

Median session length using MobileWikiAppSessions
ActivePublic
Actions

Authored by • chelsyx on Jan 16 2018, 10:30 PM.

Tags

None

Referenced Files

	F12603050: Median session length using MobileWikiAppSessions
	Jan 16 2018, 10:30 PM

Subscribers

None

	SELECT
	percentile(event.length, 0.5) AS time_50th
	FROM event.mobilewikiappsessions
	WHERE useragent.os_family = 'Android'
	AND event.totalPages + event.fromBack > 1 -- sessions with only one pageview are not counted
	AND event.length > -1
	AND event.totalPages > -1
	AND event.fromBack > -1
	AND year = 2017
	AND month = 12
	AND day >= 3
	AND day <= 9

Event Timeline

• chelsyx created this paste.Jan 16 2018, 10:30 PM