Database Reference
In-Depth Information
[Minute],
COUNT(ts) [Records],
SUM(IF(screen_on, 1, 0)) / COUNT(ts)
[FracScreenOn],
SUM(IF(power.charging, 1, 0)) / COUNT(ts)
[FracCharging],
SUM(IF(power.charge > 0.5, 1, 0)) / COUNT(ts)
[FracHalfCharged]
FROM TABLE_DATE_RANGE(logs.device_,
DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'),
CURRENT_TIMESTAMP())
WHERE TIMESTAMP_TO_USEC(ts) > (NOW() - 24 * 60 *
60 * 1000 * 1000)
GROUP BY 1
ORDER BY 1''',
'records_per_minute'
),
max_age='10m'
),
BackgroundQuery(
_dashboard_query_job(
'''SELECT running.name, COUNT(id)
FROM TABLE_DATE_RANGE(logs.device_,
DATE_ADD(CURRENT_TIMESTAMP(), -6, 'DAY'),
CURRENT_TIMESTAMP())
WHERE LEFT(running.name, LENGTH('com.android.'))
!= 'com.android.'
AND LEFT(running.name, LENGTH('android.')) !=
'android.'
AND LEFT(running.name, LENGTH('com.google.')) !=
'com.google.'
AND LEFT(running.name, LENGTH('com.motorola.'))
!= 'com.motorola.'
AND LEFT(running.name, LENGTH('com.qualcomm.'))
!= 'com.qualcomm.'
AND running.name NOT IN (
