There is a more recent run of this report. Click here to view it.

Report not found

There was a problem finding this report.
XXX Case Study - Weekly Active Users
September 8, 2014 · Refreshed almost 5 years ago
Description
Weekly active users, rolling daily.

Collaborators

Run History
SELECT drp.time_id, COUNT(DISTINCT e.user_id) AS weekly_active_users FROM benn.dimension_rollup_periods drp LEFT JOIN tutorial.yammer_events e ON e.occurred_at >= drp.pst_start AND e.occurred_at < drp.pst_end AND e.event_type = 'engagement' AND e.event_name = 'login' WHERE drp.period_id = 1007 AND drp.time_id >= '2014-06-01' AND drp.time_id < '2014-09-01' GROUP BY 1 ORDER BY 1
SELECT drp.time_id, COUNT(DISTINCT e.user_id) AS weekly_active_users FROM benn.dimension_rollup_periods drp LEFT JOIN tutorial.yammer_events e ON e.occurred_at >= drp.pst_start AND e.occurred_at < drp.pst_end AND e.event_type = 'engagement' AND e.event_name = 'login' WHERE drp.period_id = 1007 AND drp.time_id >= '2014-06-01' AND drp.time_id < '2014-09-01' GROUP BY 1 ORDER BY 1
<div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_0ed6c8444ab5" dataset="dataset" options="chart_options"></mode-chart> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled