Marco,
Thank you I have used that before and it does work for day to day. The data I am interested in though is for the month, so the MIN, MAX, AVG for the month. I wonder if there is a way to do this via SQL query instead? I am not so much worried about the chart because the SLM/SLA provides me a chat for the month with business hours, but I am not able to display the calculated data to it at the bottom of the chart/report Like I am in the PRD see below:
*This info is what Im looking for the Min, Max, Avg , Standard Deviation to add to my report but these numbers do not reflect business hours they reflect 24 hours a day for the month.
Do you think its possible to pull this with a SQL query and do the math for the month and come up with those numbers?