Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P6534
Number of searches (closing panel or choosing saved filter) on dewiki per day
Active
Public
Actions
Authored by
Catrope
on Jan 4 2018, 10:33 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F12250128: Number of searches (closing panel or choosing saved filter) on dewiki per day
Jan 4 2018, 10:33 PM
2018-01-04 22:33:46 (UTC+0)
Subscribers
None
mysql:research@analytics-slave [log]> select substring(timestamp,1,8) as day, count(distinct event_groupIdentifier) from ChangesListFilterGrouping_17008168 where event_action!='removefilter' and wiki='dew
iki' group by day;
+----------+---------------------------------------+
| day | count(distinct event_groupIdentifier) |
+----------+---------------------------------------+
| 20171006 | 32 |
| 20171007 | 46 |
| 20171008 | 72 |
| 20171009 | 30 |
| 20171010 | 38 |
| 20171011 | 31 |
| 20171012 | 50 |
| 20171013 | 11 |
| 20171014 | 5 |
| 20171015 | 2 |
| 20171016 | 7 |
| 20171017 | 3 |
| 20171018 | 4 |
| 20171019 | 2 |
| 20171020 | 5 |
| 20171021 | 3 |
| 20171022 | 4 |
| 20171023 | 9 |
| 20171024 | 3 |
| 20171025 | 2 |
| 20171026 | 6 |
| 20171027 | 3 |
| 20171028 | 6 |
| 20171029 | 6 |
| 20171030 | 12 |
| 20171031 | 6 |
| 20171101 | 3 |
| 20171102 | 1 |
| 20171103 | 3 |
| 20171104 | 5 |
| 20171105 | 4 |
| 20171106 | 6 |
| 20171107 | 4 |
| 20171108 | 6 |
| 20171109 | 1 |
| 20171110 | 3 |
| 20171111 | 3 |
| 20171112 | 4 |
| 20171113 | 2 |
| 20171114 | 4 |
| 20171115 | 36 |
| 20171116 | 83 |
| 20171117 | 53 |
| 20171118 | 49 |
| 20171119 | 69 |
| 20171120 | 46 |
| 20171121 | 34 |
| 20171122 | 52 |
| 20171123 | 32 |
| 20171124 | 22 |
| 20171125 | 22 |
| 20171126 | 24 |
| 20171127 | 31 |
| 20171128 | 35 |
| 20171129 | 22 |
| 20171130 | 32 |
| 20171201 | 17 |
| 20171202 | 31 |
| 20171203 | 26 |
| 20171204 | 35 |
| 20171205 | 20 |
| 20171206 | 35 |
| 20171207 | 31 |
| 20171208 | 43 |
| 20171209 | 27 |
| 20171210 | 45 |
| 20171211 | 51 |
| 20171212 | 45 |
| 20171213 | 28 |
| 20171214 | 63 |
| 20171215 | 39 |
| 20171216 | 34 |
| 20171217 | 53 |
| 20171218 | 57 |
| 20171219 | 46 |
| 20171220 | 34 |
| 20171221 | 43 |
| 20171222 | 46 |
| 20171223 | 25 |
| 20171224 | 47 |
| 20171225 | 31 |
| 20171226 | 29 |
| 20171227 | 40 |
| 20171228 | 25 |
| 20171229 | 25 |
| 20171230 | 40 |
| 20171231 | 21 |
| 20180101 | 23 |
| 20180102 | 30 |
| 20180103 | 4 |
+----------+---------------------------------------+
90 rows in set (0.57 sec)
Event Timeline
Catrope
created this paste.
Jan 4 2018, 10:33 PM
2018-01-04 22:33:46 (UTC+0)
Catrope
mentioned this in
T184112: Metrics: Pull stats to measure New Filters progress
.
Jan 4 2018, 10:42 PM
2018-01-04 22:42:08 (UTC+0)
Log In to Comment