search

mozilla / fxa-activity-metrics

A server for managing the Firefox Accounts metrics database and pipeline
1 stars 3 forks source link

Widen the window of multi-device users in Re:Dash #101

Closed davismtl closed 6 years ago

davismtl commented 6 years ago

In Re:Dash, we have a table called "strict_daily_multi_device_users"

It only has a rolling 3 month window of data in it. We don't seem to have a 50% or 10% sampled version of this table.

I see two options: 1) Add sampled tables for wider windows 2) Allow the table to go back 12 months so we can more easily follow trends.

edit: example of chart I was trying to look at: https://sql.telemetry.mozilla.org/queries/52228/source#139290

davismtl commented 6 years ago

CC @irrationalagent

davismtl commented 6 years ago

I might be wrong. I think we do have sampled tables. Might close this in 2 mins.

I was looking at "strict". We have "daily_multi_device_users_sampled_50"

davismtl commented 6 years ago

Closing this. I made a mistake. Everything is good.

Sorry to disturb. ;)