Page MenuHomePhabricator
Paste P6534

Number of searches (closing panel or choosing saved filter) on dewiki per day
ActivePublic

Authored by Catrope on Jan 4 2018, 10:33 PM.
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)