Ratio of Android app views with a scroll action
ActivePublic
Actions

Authored by • Tbayer on Jun 26 2017, 9:44 AM.

Tags

Referenced Files

	F8530149: Ratio of Android app views with a scroll action
	Jun 26 2017, 9:44 AM

Subscribers

None

	SELECT DATE(timestamp) AS date, SUM(IF(event_scrollFluxDown >0, 1, 0))/SUM(1), SUM(1) FROM log.MobileWikiAppPageScroll_14591606 WHERE timestamp LIKE '201706%' GROUP BY date ORDER BY date;
	+------------+-----------------------------------------------+--------+
	\| date \| SUM(IF(event_scrollFluxDown >0, 1, 0))/SUM(1) \| SUM(1) \|
	+------------+-----------------------------------------------+--------+
	\| 2017-06-01 \| 0.6752 \| 274454 \|
	\| 2017-06-02 \| 0.6748 \| 272759 \|
	\| 2017-06-03 \| 0.6760 \| 313623 \|
	\| 2017-06-04 \| 0.6837 \| 345467 \|
	\| 2017-06-05 \| 0.6701 \| 317938 \|
	\| 2017-06-06 \| 0.6786 \| 282861 \|
	\| 2017-06-07 \| 0.6754 \| 283271 \|
	\| 2017-06-08 \| 0.6771 \| 275426 \|
	\| 2017-06-09 \| 0.6785 \| 275517 \|
	\| 2017-06-10 \| 0.6846 \| 307120 \|
	\| 2017-06-11 \| 0.6864 \| 339644 \|
	\| 2017-06-12 \| 0.6799 \| 295564 \|
	\| 2017-06-13 \| 0.6772 \| 282240 \|
	\| 2017-06-14 \| 0.6745 \| 271561 \|
	\| 2017-06-15 \| 0.6822 \| 276704 \|
	\| 2017-06-16 \| 0.6777 \| 276159 \|
	\| 2017-06-17 \| 0.6832 \| 307035 \|
	\| 2017-06-18 \| 0.6846 \| 335718 \|
	\| 2017-06-19 \| 0.6826 \| 278552 \|
	\| 2017-06-20 \| 0.6781 \| 271715 \|
	\| 2017-06-21 \| 0.6815 \| 269305 \|
	\| 2017-06-22 \| 0.6842 \| 268307 \|
	\| 2017-06-23 \| 0.6799 \| 268797 \|
	\| 2017-06-24 \| 0.6786 \| 302341 \|
	\| 2017-06-25 \| 0.6904 \| 328988 \|
	\| 2017-06-26 \| 0.6907 \| 93011 \|
	+------------+-----------------------------------------------+--------+
	26 rows in set (1 min 14.82 sec)

Event Timeline

	SELECT DATE(timestamp) AS date, SUM(IF(event_scrollFluxDown >0, 1, 0))/SUM(1), SUM(1) FROM log.MobileWikiAppPageScroll_14591606 WHERE timestamp LIKE '201706%' GROUP BY date ORDER BY date;
	+------------+-----------------------------------------------+--------+
	\| date \| SUM(IF(event_scrollFluxDown >0, 1, 0))/SUM(1) \| SUM(1) \|
	+------------+-----------------------------------------------+--------+
	\| 2017-06-01 \| 0.6752 \| 274454 \|
	\| 2017-06-02 \| 0.6748 \| 272759 \|
	\| 2017-06-03 \| 0.6760 \| 313623 \|
	\| 2017-06-04 \| 0.6837 \| 345467 \|
	\| 2017-06-05 \| 0.6701 \| 317938 \|
	\| 2017-06-06 \| 0.6786 \| 282861 \|
	\| 2017-06-07 \| 0.6754 \| 283271 \|
	\| 2017-06-08 \| 0.6771 \| 275426 \|
	\| 2017-06-09 \| 0.6785 \| 275517 \|
	\| 2017-06-10 \| 0.6846 \| 307120 \|
	\| 2017-06-11 \| 0.6864 \| 339644 \|
	\| 2017-06-12 \| 0.6799 \| 295564 \|
	\| 2017-06-13 \| 0.6772 \| 282240 \|
	\| 2017-06-14 \| 0.6745 \| 271561 \|
	\| 2017-06-15 \| 0.6822 \| 276704 \|
	\| 2017-06-16 \| 0.6777 \| 276159 \|
	\| 2017-06-17 \| 0.6832 \| 307035 \|
	\| 2017-06-18 \| 0.6846 \| 335718 \|
	\| 2017-06-19 \| 0.6826 \| 278552 \|
	\| 2017-06-20 \| 0.6781 \| 271715 \|
	\| 2017-06-21 \| 0.6815 \| 269305 \|
	\| 2017-06-22 \| 0.6842 \| 268307 \|
	\| 2017-06-23 \| 0.6799 \| 268797 \|
	\| 2017-06-24 \| 0.6786 \| 302341 \|
	\| 2017-06-25 \| 0.6904 \| 328988 \|
	\| 2017-06-26 \| 0.6907 \| 93011 \|
	+------------+-----------------------------------------------+--------+
	26 rows in set (1 min 14.82 sec)