topic Re: Set resolution to 1 day with Data explorer in Open Q&A

Set resolution to 1 day with Data explorer

Shirai — Wed, 11 May 2022 06:28:12 GMT

When I created a graph with a resolution of 1 day in Data explorer, I noticed a strange phenomenon. The data is aggregated from 9:00 to 9:00 the next day. I expect it to be aggregated from 0:00 to 0:00 the next day. This Environment is set to Japan time.

Re: Set resolution to 1 day with Data explorer

techean — Wed, 11 May 2022 10:38:46 GMT

this completely depend on your time frame selector. The value gets populated on the basis of selected time frame.

Re: Set resolution to 1 day with Data explorer

Shirai — Thu, 12 May 2022 00:46:53 GMT

Hi techean-san.

I changed the time frame. For example, April 11th 00:00-May 12th 00:00. Next, when I pointed to the data on May 9, it was aggregated from 9:00 on May 9 to 9:00 on May 10. So I don't think it depends on the time frame.

Re: Set resolution to 1 day with Data explorer

Shirai — Thu, 12 May 2022 00:55:23 GMT

Japan time is UTC+9. I expect this to be relevant.

I would like to know what the result will be in other time zones. Can anyone try it?

Re: Set resolution to 1 day with Data explorer

andra_nosa — Thu, 12 May 2022 02:02:13 GMT

Hi Shirai,

I tried with my environment with timeframe set on May 9 00.00 - May 10 00.00

Timezone GMT+7 Indonesian Time, if you see it start with 07:00 maybe it defends with it, but im not sure must ask with Dynatrace Experts too

Re: Set resolution to 1 day with Data explorer

techean — Thu, 12 May 2022 02:48:10 GMT

You should go ahead raising this as a support ticket as this could be a bug or product behavior designed to fetch start time of organization. Not sure right now but the dev support team would be able to analyze this further and confirm if its a behavior or a bug.

Re: Set resolution to 1 day with Data explorer

Shirai — Fri, 13 May 2022 00:33:33 GMT

Hi andra_nosa-san.

Thank you for testing. Maybe there is a problem with the time difference calculation in Data explorer.

Re: Set resolution to 1 day with Data explorer

Shirai — Thu, 12 May 2022 08:22:39 GMT

@techean @andra_nosa Thank you for your comment.

I open a support ticket for this issue.

Re: Set resolution to 1 day with Data explorer

Shirai — Fri, 13 May 2022 07:27:04 GMT

According to the support team, this is by design, not by bug. The data is stored in UTC on the server and is not converted by time zone.
However, an RFE has been posted on this issue.

https://community.dynatrace.com/t5/Dynatrace-product-ideas/RFE-API-with-timezone-support/idi-p/152443

We hope that RFE will be adopted and this problem will be resolved.

Re: Set resolution to 1 day with Data explorer

techean — Fri, 13 May 2022 09:55:23 GMT

So finally its a product behavior right? lets see if the idea gets maximum vote and is planned for development as a feature, this will get solved.

Re: Set resolution to 1 day with Data explorer

ashokkuanar — Fri, 18 Oct 2024 12:48:44 GMT

i am also facing same issue, this should be 00:00 to next day 00:00