dynatrace-oss / DynatraceDashboardPowerups

Chrome Extension to boost DT dashboards
Apache License 2.0
39 stars 12 forks source link

Enhancement Request: Business Hour Reporting #143

Open TechShady opened 2 years ago

TechShady commented 2 years ago

Create a power up that will remove datapoints from a time series graph that fall out of business hours. For example, I have a graph that shows AVG duration for each hour interval over the last 7 days. So a PU like !PU(bizhours):starttime:08:00;endtime:17:00. The the power up would remove all data points that are outside of 9am to 5pm. Maybe add in a parameter to include/exclude weekends.

kegillette commented 2 years ago

This is perfect and agree this is huge need for Dynatrace engineers. There is a RFE for it https://community.dynatrace.com/t5/Dynatrace-product-ideas/RFE-Support-for-Business-Hours-in-timeframe-selector/idi-p/154613

Philippe112 commented 2 years ago

+1

I am trying to powerups for a heatmap during business hours only throughout a week and it will not report on the hours set within dynatraces custom timeframe reporting: image

TechShady commented 2 years ago

I think I can create a specific workflow in the BizOps Configurator. Here's what I'm thinking. The workflow will prompt for the interval...in your case that - 16:00-9:00 or 7 hours. I can then add in a prompt for business days. In your case that will be 6 days. I will support 5, 6 or 7 days as business days. The dashboard will work off of the beginning timeframe and then go from there. So you will deploy with 7 hours and 6 days. As long as you put your timeframe on any Tuesday at 9:00am, it should work. If you had your timeframe on Wednesday, it would display Wednesday - Monday. And if you had the hour at 10:00 am, it would calculate for 10:00am - 17:00pm. If that approach works for you, let me know and I'll test it out. But thinking that should work...

Philippe112 commented 2 years ago

That sounds amazing!!! I think to start out we would want 5 days or Monday to Friday and have the hour interval either be 0900 to 1600 or 1700. Lastly another piece of complexity that sometimes arises comes from timezones. If we could add just a simple timezone (sometimes ZZ in date-fns) label to show what time zone is being reported on that would be amazing-er.

TechShady commented 2 years ago

I made some changes and got things working for now. There are a few limitations that I will work on next week. Here's the workflow (connect to the configurator with GitHub as the changes I made won't be promoted to S3 until this evening): https://dynatrace.github.io/BizOpsConfigurator/#deploy/persona/App%20Owner/Application%20Overview/Application%20Heatmap%20(%F0%9F%92%8E) Limit the app selection to 2-10. I need to make a change to get around the Explorer 10 row limit and will do that next week. For the interval, use -1d as this makes the most sense for working hours heatmap. For round down, use /d as this too makes the most sense. I added 2 new widgets for start time and end time. I'll make that select easier next week, but for now use something like:

StartTime: +9h00m EndTime: +17h00m

The good news is you don't have to mess with the global timeframe as every tile is autogenerated. So if I have a timeframe for anytime today, the heatmap will have day 1 as yesterday...9-5...and so on.

Let me know your thoughts. For now, weekends are included but I'll figure out an option to include/exclude that as well.

image

kegillette commented 2 years ago

This is great but I am sure I messed up but didn’t see a StartTime or EndTime

From: TechShady @.> Sent: Tuesday, April 5, 2022 1:45 PM To: dynatrace-oss/DynatraceDashboardPowerups @.> Cc: Kenneth Gillette @.>; Comment @.> Subject: Re: [dynatrace-oss/DynatraceDashboardPowerups] Enhancement Request: Business Hour Reporting (Issue #143)

I made some changes and got things working for now. There are a few limitations that I will work on next week. Here's the workflow (connect to the configurator with GitHub as the changes I made won't be promoted to S3 until this evening): https://dynatrace.github.io/BizOpsConfigurator/#deploy/persona/App%20Owner/Application%20Overview/Application%20Heatmap%20(%F0%9F%92%8E)https://urldefense.com/v3/__https:/dynatrace.github.io/BizOpsConfigurator/*deploy/persona/App*20Owner/Application*20Overview/Application*20Heatmap*20(**C)__;IyUlJSXwn5KO!!Cz2fjcuE!gUjFYiUIBPbUtzqZlHTFcstJErQl77FP8CO7oY84fN3X3ymtICrziYw671f4QCvcQqhPXJphC__EJh1KGpP3rMOAYT5dElIFYAw$ Limit the app selection to 2-10. I need to make a change to get around the Explorer 10 row limit and will do that next week. For the interval, use -1d as this makes the most sense for working hours heatmap. For round down, use /d as this too makes the most sense. I added 2 new widgets for start time and end time. I'll make that select easier next week, but for now use something like:

StartTime: +9h00m EndTime: +17h00m

The good news is you don't have to mess with the global timeframe as every tile is autogenerated. So if I have a timeframe for anytime today, the heatmap will have day 1 as yesterday...9-5...and so on.

Let me know your thoughts. For now, weekends are included but I'll figure out an option to include/exclude that as well.

[image]https://urldefense.com/v3/__https:/user-images.githubusercontent.com/21313331/161817365-3ba4b56f-2a26-4838-9616-e1be4f9c9735.png__;!!Cz2fjcuE!gUjFYiUIBPbUtzqZlHTFcstJErQl77FP8CO7oY84fN3X3ymtICrziYw671f4QCvcQqhPXJphC__EJh1KGpP3rMOAYT5dIfZP8-o$

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/dynatrace-oss/DynatraceDashboardPowerups/issues/143*issuecomment-1089106036__;Iw!!Cz2fjcuE!gUjFYiUIBPbUtzqZlHTFcstJErQl77FP8CO7oY84fN3X3ymtICrziYw671f4QCvcQqhPXJphC__EJh1KGpP3rMOAYT5dnPlVguE$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AXWBYE3YZVL6UYZAYNCAOS3VDR3Y7ANCNFSM5RCL5FTQ__;!!Cz2fjcuE!gUjFYiUIBPbUtzqZlHTFcstJErQl77FP8CO7oY84fN3X3ymtICrziYw671f4QCvcQqhPXJphC__EJh1KGpP3rMOAYT5dnM8glTk$. You are receiving this because you commented.Message ID: @.**@.>>


The information contained in this email message is being transmitted to and is intended for the use of only the individual(s) to whom it is addressed. If the reader of this message is not the intended recipient, you are hereby advised that any dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please immediately delete.

Member FINRAhttp://www.Finra.org / SIPChttp://www.Sipc.org Copyright 2017 – LPL Financial. All Rights Reserved.