made dw_dashboard view account for time zone