Group Time Series by Month or Year

[JhonU]

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

[Eric_Yu · Accepted solution]

Hi Jhon,

You can try playing around with the interval agregation:

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