Help creating report or dashboard using javascript created today at or before 8:30am?

[khogan]

Hello,

I am trying to create report against the table change_request_metric.  That returns records in Authorized state, at or before today 8:30am. Also remove duplicate records, in the metric table only return the latest record in authorized. I can get the time 8:30am just fine in a list view. Example below. But I cannot do it in a report or dashboard. Looks like when I use created and trend, every hour is available but not half hours.

They want this as a dashboard for change review meetings, they do not want a scheduled report emailed.

Any suggestions would be appreciated.

/change_request_metric_list.do?sysparm_query=chg_state%3D-3%5Echg_active%3Dtrue%5Emi_definition%3Dc0f4f1e51bc36d509d932f88624bcbd9%5Emi_value%3DAuthorize%5Emi_sys_created_on<javascript&colon;gs.dateGenerate(gs.now()%2C%2708:30:00%27)&sysparm_first_row=1&sysparm_view=