https://community.dynatrace.com/t5/DQL/Group-Time-Series-by-Month-or-Year/m-p/245421#M880 <P>Hi, maybe this is a simple thing but I'm just starting out in the world of Dynatrace DQL. I have a time series</P><P>timeseries fd=sum(cloud.aws.cloudfront.requests_sum_by_region)</P><P>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.</P><P>I appreciate you if you have any ideas that can guide me</P> Mon, 13 May 2024 12:45:42 GMT JhonU 2024-05-13T12:45:42Z https://community.dynatrace.com/t5/DQL/Group-Time-Series-by-Month-or-Year/m-p/245421#M880 <P>Hi, maybe this is a simple thing but I'm just starting out in the world of Dynatrace DQL. I have a time series</P><P>timeseries fd=sum(cloud.aws.cloudfront.requests_sum_by_region)</P><P>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.</P><P>I appreciate you if you have any ideas that can guide me</P> Mon, 13 May 2024 12:45:42 GMT https://community.dynatrace.com/t5/DQL/Group-Time-Series-by-Month-or-Year/m-p/245421#M880 JhonU 2024-05-13T12:45:42Z https://community.dynatrace.com/t5/DQL/Group-Time-Series-by-Month-or-Year/m-p/245476#M882 <P>Hi Jhon,</P><P>You can try playing around with the interval agregation:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Eric_Yu_0-1715637034904.png" style="width: 591px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/19787i0D2074D46298AA58/image-dimensions/591x246?v=v2" width="591" height="246" role="button" title="Eric_Yu_0-1715637034904.png" alt="Eric_Yu_0-1715637034904.png" /></span></P><P><A href="https://docs.dynatrace.com/docs/shortlink/metric-commands" target="_blank" rel="noopener">https://docs.dynatrace.com/docs/shortlink/metric-commands</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Eric_Yu_1-1715637053322.png" style="width: 736px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/19788iB8C91C817BDF7012/image-dimensions/736x567?v=v2" width="736" height="567" role="button" title="Eric_Yu_1-1715637053322.png" alt="Eric_Yu_1-1715637053322.png" /></span></P> Mon, 13 May 2024 21:51:30 GMT https://community.dynatrace.com/t5/DQL/Group-Time-Series-by-Month-or-Year/m-p/245476#M882 Eric_Yu 2024-05-13T21:51:30Z