REPORT PARAMETERS

Report not found

There was a problem finding this report.
User Lookup Example
March 26, 2015 · Refreshed 10 months ago

Collaborators

Run History
SELECT z.user_id, z.last_logged_in FROM ( SELECT u.user_id, MAX(CASE WHEN e.device ILIKE '%samsung%' THEN 1 ELSE 0 END) AS used_device, MAX(e.occurred_at) AS last_logged_in FROM tutorial.playbook_events e JOIN tutorial.playbook_users u ON u.user_id = e.user_id AND u.language = 'english' AND u.state = 'active' GROUP BY 1 ) z WHERE z.last_logged_in <= NOW() - INTERVAL '60 DAY' AND z.used_device = 1
SELECT z.user_id, z.last_logged_in FROM ( SELECT u.user_id, MAX(CASE WHEN e.device ILIKE '%{{device_type}}%' THEN 1 ELSE 0 END) AS used_device, MAX(e.occurred_at) AS last_logged_in FROM tutorial.playbook_events e JOIN tutorial.playbook_users u ON u.user_id = e.user_id AND u.language = '{{language}}' AND u.state = 'active' GROUP BY 1 ) z WHERE z.last_logged_in <= NOW() - INTERVAL '{{days_since_last_login}} DAY' AND z.used_device = 1 {% form %} days_since_last_login: type: text default: 30 language: type: select default: english options: [[english,english], [french,french], [spanish,spanish], [japanese,japanese]] device_type: type: select default: iphone options: [[iphone,iphone], [samsung,samsung], [nexus,nexus]] {% endform %}
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-table id="table_8bba38ea76a0" dataset="dataset" options="table_options"></mode-table> </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