How to set a custom timeframe which is shifted from the base timeframe?

[istvan_safranek]

Hello!

I have a dashboard with 4 tiles. Each shows key request statistics.

I want to clone these tiles and set a custom timeframe which is shifted from the dashboard base timeframe with x minutes or hours or days etc.

Is this possible to set shifted timeframe?

[KaliprasadP]

Hello @istvan_safranek ,

There is an option for that once you select the tile in edit mode, in data explore you have a custom timeframe, you can set time for the tile, based on your request.

Regards

Kaliprasad P

[istvan_safranek]

Hello @KaliprasadP 

Unfortunately it's not good for me. If I set the tile's custom timeframe to Yesterday, it will always show Yesterday's data if I change the dashboard main timeframe in the upper right corner.

br, Istvan

[zietho · Accepted solution]

You can apply the timeshifts in the Data explorer itself using the code mode (see last illustration below how to do it) and it will then also take the selected timeframe on the dashboard into account like

Doc links: 

https://www.dynatrace.com/support/help/shortlink/explorer-advanced-query-editor#example-compare-a-me... 

https://www.dynatrace.com/support/help/shortlink/api-metrics-v2-selector#time-shift-transformation 

Hope that helps. 

Regards 

Thomas

[istvan_safranek]

@ziethothank you. I will try it on a normal Graph tile. Unfortanetly the Service or request tile has no option to see the data explorer. Would be nice to be there too.

[zietho]

Yes and no. 

They usually underly metrics. The moment you find the metric you can use any of the Data explorer tiles (+ timeshift in code mode) to do it. Honeycombs will hit the stage in Q1/early Q2 so you can "partially" replicate the service health tile. However, the tiles are then based on metrics, not problems, for a start. 

Problems on top we also will look into later next year though. 

cheers. 

[Yosi_Neuman]

Hi @zietho 

The only problem with your suggestion is that the shift is with in the time of the time picker which mean that if you want to show count for whole day yesterday , month ago and 3 month ago IMO it will not work. 

What we done for this is to set the time picker in each tile for, today  , yesterday , 1 day 7 day ago (-7d/d to -6d/d), 1 day 30 day ago (-30d/d to -29d/d)

You can also adjust the start and end time in day as appears in the timeframe selector guide 

HTH

Yos 

[zietho]

Yes you are right but my answer was intentional to providing means to shift according to the selected timeframe. 

So in essence there are two ways you can shift: 

* static shifts according to the current time => select custom timeframe for a tile

* dynamic shifts according to the selected time frame => :timeshift transformation in the Data explorer 

Hope that clarifies what you can do. 

regards 

[username1]

How do I apply Timeshift in DQL?

[zietho]

Check out an example ok this dashboard: https://wkf10640.apps.dynatrace.com/ui/document/v0/#share=b2414393-2ab2-429b-9cc9-0900595c5f75 

or you can use „Explore metrics“ and add the „Compare to previous period“