Hello, I am new to ReDash and I need to create a viz with following data (user sessions on the website):
3 columns: user_id, start_at (date-time format), end_at (date-time format)
The viz should include the following:
- average (or median) duration of session (actually simple end_at minus start_et)
- distribution od session within time of day (morning, noon, evening, etc, can be done with “case when” but how?)
- any abnormalities if where are any (e.g. extremely long sessions, night with unsually big number of sessions, etc.)
How to do this using ReDash viz tools? Should I define all the values using SQL-queries or where are any options only within viz app?