Is it possible somehow to add business hours to a PRD report? Or include it in the filter some how so that I can see the MIN, MAX, and AVG for my chart but not for 24hours a day for 30 days(Month)? So for example if I create a report for a switch and in the report I look at its Availability and 2 different interfaces and there Utilization in and out I get the graph in the PRD and I get the table at the bottom that gives me my MIN, MAX, and AVG. I can run that for the last month but is it possible to only run that for a set 8 hour period or set of Business hours 8:00 AM to 5:00 PM?
If you are looking to create a report for business hours only over multiple days this is is not possible.
However, a part from the predefined last hour, last day, las week or last month It is possible to create a custom time frame (click on the blue arrow for more options).
and create a report for a specific day and hours.
ie: 8/7 from 8 to 18 :
would that do?
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?