Steps to reproduce
Query event counts in MobileWikiAppCreateAccount, values for event.action = success are null/0 past timestamps of 2022-08-19 (except for a single '1' value on 2022-08-23). The null/counts apply to every source.
Counts for event.action = start are incrementing as expected.
Expected results
We should be seeing event counts for event.action = success.
Actual results.
| Date | Start | Success | Error |
|---|---|---|---|
| 2022-08-15 | 3841 | 473 | 0 |
| 2022-08-16 | 3625 | 507 | 0 |
| 2022-08-17 | 4163 | 473 | 0 |
| 2022-08-18 | 3559 | 370 | 0 |
| 2022-08-19 | 4017 | 0 | 0 |
| 2022-08-20 | 4270 | 0 | 0 |
| 2022-08-21 | 4424 | 0 | 0 |
| 2022-08-22 | 3976 | 0 | 0 |
| 2022-08-23 | 4192 | 1 | 0 |
| 2022-08-24 | 4088 | 0 | 0 |
Environments observed
Query
SELECT CAST(FROM_ISO8601_TIMESTAMP(dt) AS DATE) AS DATE, count(*) as count, event.action FROM event.mobilewikiappcreateaccount WHERE YEAR = 2022 AND MONTH >= 8 AND DAY >= 1 AND regexp_like(useragent.wmf_app_version, '-r-') AND CAST(FROM_ISO8601_TIMESTAMP(dt) AS DATE) < current_date GROUP BY CAST(FROM_ISO8601_TIMESTAMP(dt) AS DATE), event.action ORDER BY CAST(FROM_ISO8601_TIMESTAMP(dt) AS DATE)