I've created a query that shows all calls in a certain group that are at the status of "open" - no problem.
The management now want to show this data at a set time twice a day (07:00 & 17:00) only,
Does anyone know how I could achieve this with out having to manually change the date/times each day? I currently have the query running in dashboard showing the current total but this total obviously changes throughout the day.
Any help much appreciated.