real_time_dashboard_usage.sql

select 
  public.view_log.timestamp + interval '2 hours' as event_at,
  public.report_dashboard.name,
  public.core_user.first_name,
  public.core_user.last_name
from public.view_log
inner join public.report_dashboard on (public.report_dashboard.id = public.view_log_model_id)
inner join public.core_user on (public.view_log_user_id = public.core_user_id) 
where public.view_log.model = 'dashboard'
and public.view_log.timestamp > current_date - 2
order by 1 desc