cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Group Time Series by Month or Year

JhonU
Visitor

Hi, maybe this is a simple thing but I'm just starting out in the world of Dynatrace DQL. I have a time series

timeseries fd=sum(cloud.aws.cloudfront.requests_sum_by_region)

and I need to analyze the seasonality, for this it is necessary to obtain the maximums either by day, month or week, the time series returns a timeframe I do not know how I could group this timeframe into months or weeks I have seen documentation and in itself everything is given for a timestamp.

I appreciate you if you have any ideas that can guide me

1 REPLY 1

Eric_Yu
Dynatrace Advisor
Dynatrace Advisor

Hi Jhon,

You can try playing around with the interval agregation:

Eric_Yu_0-1715637034904.png

https://docs.dynatrace.com/docs/shortlink/metric-commands

Eric_Yu_1-1715637053322.png

Eric Yu

Featured Posts