29
edits
(Added client count dataset) |
(Added crash aggregates) |
||
Line 30: | Line 30: | ||
The Client Count dataset is simply a count of clients in a time period, separated out into a set of dimensions. | The Client Count dataset is simply a count of clients in a time period, separated out into a set of dimensions. | ||
This is useful for questions similar to: '' | This is useful for questions similar to: ''How many X type of users were there during Y?'' - where X is some dimensions, and Y is some dates. Examples of X are: E10s Enabled, Operating System Type, or Country. For a complete list of dimensions, see [https://github.com/mozilla/telemetry-batch-view/blob/master/src/main/scala/com/mozilla/telemetry/views/ClientCountView.scala#L22 here]. | ||
Client Count does not contain a traditional int count column, instead the counts are stored as a HyperLogLogs in the hll column. The count of the hll is found using <code>cardinality(cast(hll AS HLL))</code>, and different hll's can be merged using <code>merge(cast(hll AS HLL))</code>. An example can be found in the [https://sql.telemetry.mozilla.org/queries/81/source#129 Firefox ER Reporting]. | Client Count does not contain a traditional int count column, instead the counts are stored as a HyperLogLogs in the hll column. The count of the hll is found using <code>cardinality(cast(hll AS HLL))</code>, and different hll's can be merged using <code>merge(cast(hll AS HLL))</code>. An example can be found in the [https://sql.telemetry.mozilla.org/queries/81/source#129 Firefox ER Reporting]. | ||
Line 39: | Line 39: | ||
==Crash Aggregates== | ==Crash Aggregates== | ||
[https://github.com/mozilla/telemetry-batch-view/blob/master/docs/CrashAggregateView.md Complete Documentation] | |||
The Crash Aggregates dataset compiles crash statistics over various dimensions for each day. Example dimensions include channel and country, example statistics include usage hours and plugin crashes. See the [https://github.com/mozilla/telemetry-batch-view/blob/master/docs/CrashAggregateView.md complete documentation] for all available dimensions and statistics. | |||
This dataset is good for queries of the form ''How many crashes did X types of users get during time Y?'' and ''Which types of users crashed the most during time Y?''. | |||
==Mobile Metrics== | ==Mobile Metrics== | ||
The android_events, android_clients, android_addons, and mobile_clients tables are documented here: | The android_events, android_clients, android_addons, and mobile_clients tables are documented here: | ||
https://wiki.mozilla.org/Mobile/Metrics/Redash | https://wiki.mozilla.org/Mobile/Metrics/Redash |
edits