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)