BACK TO QUERY LIST

Is there a difference in the user experience between different devices?

For example, what is the median session duration in minutes, breakdown by user device?

SELECT avg(median) AS median_session_duration_mins, session_os
FROM
  (SELECT percentile_cont(0.5) OVER (PARTITION BY session_os ORDER BY p_duration) AS median, session_os
   FROM
     (SELECT path_duration() /1000/60 AS p_duration, session_os
      FROM cooladata
      WHERE date_range (doc.date_range)  
         ) )
GROUP BY session_os
Segentation
Behavioral
pivot table