Report not found

There was a problem finding this report.

Report

Average Sessions Per User

Average sessions per user
June 14, 2016 · Refreshed 3 months ago
Description
Average sessions per user

Collaborators

Run History
SELECT ROUND(COUNT(DISTINCT session_id)::DECIMAL / COUNT(DISTINCT user_id), 2) as average_user_sessions FROM heap.sessions -- modify the date range here WHERE time >= DATEADD('day', - 30, GETDATE())
SELECT ROUND(COUNT(DISTINCT session_id)::DECIMAL / COUNT(DISTINCT user_id), 2) as average_user_sessions FROM heap.sessions -- modify the date range here WHERE time >= DATEADD('day', - 30, GETDATE())
<div class="mode-header"> <h1 class='embed-hidden'>{{ title }}</h1> <p>{{ description }}</p> <p id="big_number"></p> </div> <script> document.getElementById('big_number').innerHTML=datasets[0].content[0].average_user_sessions </script> <style> #big_number{ font-size:36px; } </style> <div class="mode-grid container"></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