timeonsite_analytics

If you are looking for visualizing with minimal data, you may find visual readily available. For large dataset and querying complex data, use timeonsite_analytics
Use Mysql sample data available https://github.com/saleemkce/tos_dump/tree/master/php till you generate timeonsite data from your application. Use the zip file that contains sample data. 100K records available for querying, analytics and finding insights
Learn more about timeonsite analytics at Medium blog post
Recent 10 sessions - Query
Short & Long visit by page - Query

Name		Name	Last commit message	Last commit date
Latest commit History 9 Commits
README.md		README.md
find_bounce_rated_session_details.sql		find_bounce_rated_session_details.sql
find_bounce_rated_sessions.sql		find_bounce_rated_sessions.sql
tos_get_duration.sql		tos_get_duration.sql
tos_large_session_detailed_stats.sql		tos_large_session_detailed_stats.sql
tos_post_pageview_time_spent.sql		tos_post_pageview_time_spent.sql
tos_short_long_visit_posts.sql		tos_short_long_visit_posts.sql
tos_single_post_last_month_pageview_time_spent.sql		tos_single_post_last_month_pageview_time_spent.sql
tos_single_post_pageview_time_spent.sql		tos_single_post_pageview_time_spent.sql
tos_ten_big_sessions_duration.sql		tos_ten_big_sessions_duration.sql
tos_ten_recent_sessions_duration.sql		tos_ten_recent_sessions_duration.sql
tos_time_spent_by_user_type.sql		tos_time_spent_by_user_type.sql

Provide feedback