topic Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events in Custom Solutions Spotlight

PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Thu, 01 May 2025 20:39:35 GMT

It's quite common you don't provide your services 24x7, but you will run them also during non-business hours. Until business hours or business calendar features land into the Dynatrace product natively, it's possible to have a simple solution.

My approach below works for both Dynatrace Managed and SaaS.

For this feature, we will introduce a new metric - in this example business_hours which will provide just static values:

1 during business hours
no value outside of business hours
value between 0 and 1 to decrease priorities during "low business hours" (if applicable to your case)

Of course, in your environment you probably have different business hours for different services, thus you will likely need to have a dimension for it, such as level (24x7, 10x5, etc... ). See example below:

For example, values for an 8x5 service level will look like this - a value of 1 between 9:00 and 17:00 for each day and no value outside these times.

Then in the SLO definition, you will simply use metric expression and multiply your desired metric with the business hours metric with the desired dimension representing your business hours, for example - for SLO on key requests:

( builtin:service.keyRequest.successes.server.rate:splitBy():auto * business_hours:filter(and(or(eq(level,"8x5")))):splitBy():auto ):setUnit(Percent)

You may also commit the :setUnit transformation if you wish.

IMPORTANT: If the metric expression is displayed as a single value (Single value, table, etc) , please include :fold aggregation directly in the expression. This is needed due to the way Dynatrace queries metrics for single value charts. (infinite resolution).

So in the example - during business hours, your original metric will be unaffected (multiplied by 1) and outside of business hours, you will have no value. In this example I've chosen a service level of 8x5, so the result will look like this - notice there are no values during the weekend of 16th and 17th March, and during Monday - Friday we have values only between 8:00 to 16:00 - representing 8x5.

You can use this approach also in Data Explorer, for Metric event definitions or elsewhere you can utilize metric expressions!

Extension for generating business hours metric

I've decided to publish the extension which allows you to create this business_hours metric based on cron-like schedules or also from a real calendar! (defined in Office 365, Google Calendar or any remote calendar available in ical format). So you can define your business hours using a shared calendar and the extension will generate the metric accordingly.

You can download the extension from here. You will need to import the CA certificate into your Dynatrace environment and upload the extension. See the README.md for details and links on how to share calendars from Office 365 or Google Calendar.

Using calendar, you can freely define your business hours and exceptions. For example, define 8x5 as a recurring event in your calendar and just delete the occurrences, for example, for holidays.

Changelog

v0.0.16

Improved logging

v0.0.15

Added support for generating negative levels
Extension Dashboard with simple how-to and generated business hours metrics

v0.0.12

Initial public version

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

henk_stobbe — Mon, 08 Apr 2024 14:26:42 GMT

Hi Julius,

(you have fans (-;)

I am very interested in your Extension, can you share?

KR Henk

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

jiri_stefanek — Wed, 10 Apr 2024 08:10:43 GMT

Hi Julius,

I am very interested.🙂

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Thu, 18 Apr 2024 07:58:14 GMT

Hi @jiri_stefanek ,
can you please reach out to me directly at julius.loman (at) alanata.sk ?

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

jiri_stefanek — Thu, 18 Apr 2024 08:13:57 GMT

Hi Julius,

I just send you email.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

hy — Thu, 25 Apr 2024 18:16:44 GMT

Hi Julius,

I just sent you an email directly as well. Hope to hear from you soon. Thank you!

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

hy — Thu, 25 Apr 2024 18:38:50 GMT

How did you create the custom metric that defines the different business hours for different services, thus you will likely need to have a dimension for it, such as level (24x7, 10x5, etc) in data explorer?

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Fri, 26 Apr 2024 07:08:55 GMT

@hy exactly. I've just replied to your email.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

elodie_lam — Tue, 07 May 2024 16:32:57 GMT

Hi Julius, this is great! I would also be interested in your extension please 🙂

Thank you!

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

kanthv — Thu, 16 May 2024 05:06:57 GMT

Sent an email to you and looking forward for your reply mate. Thanks

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

AurelienGravier — Tue, 21 May 2024 10:13:34 GMT

Hi @Julius_Loman ,

You are so inspiring ! I have created my own python extension to create the custom metric but I use declarative endpoints with a specific format :

However, I'm encountering a limitation when I define a new business opening hours, I have to wait 1 month before use it in my SLO definition otherwise my SLO is null before the custom metric dimension creation.

Did you experiment the same behaviour with your extension ?

Thank you.
Regards Aurelien.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Tue, 21 May 2024 17:13:28 GMT

I'm not sure if I got your question. The only issue I ever encountered is that you cannot post metrics back in time. So if you define a service level you can only use it for the calculating SLO from current time.so plan accordingly and define your service levels in advance.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

AurelienGravier — Wed, 22 May 2024 07:33:47 GMT

That's exactly the limitation I'm encountering : you cannot post metrics back in time.

Thank you for your confirmation.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Wed, 22 May 2024 07:57:19 GMT

Yes, that's impossible as metrics can be ingested only one hour back in time. This will likely change soon with Grail, but not for Managed.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

rgarzon1 — Mon, 27 May 2024 16:45:21 GMT

This could be one of the most clever tricks i seen, thank you for share it @Julius_Loman

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

erh_inetum — Tue, 04 Jun 2024 06:22:11 GMT

Hi Julius,

Thanks a lot for your great post.
I also just sent you and email and like "hy" user I’m interested to know how to create the custom metric that defines the different business hours for different services.

Thanks again.
Regards,
Elena

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

germanriezu — Fri, 21 Jun 2024 11:58:17 GMT

Hi Julius, any ETA for this extension to be in the hub?

Thanks

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Fri, 21 Jun 2024 12:35:16 GMT

@germanriezu unfortunately it was not accepted. Only Dynatrace signed extensions can be in the HUB as of today, no 3rd party extensions. So at least for upcoming months this will stay as it is. You can download it from the provided link including the certificate and use it as a 3rd party extension. In case of any issues, reach out back here in this thread.

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Kumari_Sapna — Thu, 03 Apr 2025 08:32:30 GMT

Hi @Julius_Loman Thank you for sharing the detailed explanation.
But the link shared above to download the extension is not accessible Are there some restrictions or any other issues? Can you kindly confirm?
Thanks in advance

Re: PRO TIP - Business hours in Dynatrace for SLOs or metric events

Julius_Loman — Thu, 03 Apr 2025 13:37:43 GMT

@Kumari_Sapna, apparently there have been some changes to the sharing policy where this was hosted. I moved this project to github. The link was updated. Thanks for reporting.