https://community.dynatrace.com/t5/DQL/Single-avg-value-instead-full-timeseries/m-p/213679#M14 <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">I'd like to display one single value (the average of all the value of the chart) instead of a timeseries.</DIV> <DIV class="p-rich_text_section">When I choose "Single Value" display, it seems to display the values of ALL hosts, instead of one average:</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-files_container" role="none"> <DIV class="c-message_kit__file__meta"> <DIV id="tinyMceEditorstefan_eggersto_0" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <DIV id="tinyMceEditorstefan_eggersto_1" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="stefan_eggersto_2-1685542229153.png" style="width: 999px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/11995i57AA3BF0D68B72B4/image-size/large?v=v2&amp;px=999" role="button" title="stefan_eggersto_2-1685542229153.png" alt="stefan_eggersto_2-1685542229153.png" /></span> <P>&nbsp;</P> <P>&nbsp;</P> </DIV> </DIV> Wed, 31 May 2023 14:11:21 GMT stefan_eggersto 2023-05-31T14:11:21Z https://community.dynatrace.com/t5/DQL/Single-avg-value-instead-full-timeseries/m-p/213679#M14 <DIV class="c-message_kit__blocks c-message_kit__blocks--rich_text"> <DIV class="c-message__message_blocks c-message__message_blocks--rich_text" data-qa="message-text"> <DIV class="p-block_kit_renderer" data-qa="block-kit-renderer"> <DIV class="p-block_kit_renderer__block_wrapper p-block_kit_renderer__block_wrapper--first"> <DIV class="p-rich_text_block" dir="auto"> <DIV class="p-rich_text_section">I'd like to display one single value (the average of all the value of the chart) instead of a timeseries.</DIV> <DIV class="p-rich_text_section">When I choose "Single Value" display, it seems to display the values of ALL hosts, instead of one average:</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-files_container" role="none"> <DIV class="c-message_kit__file__meta"> <DIV id="tinyMceEditorstefan_eggersto_0" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <DIV id="tinyMceEditorstefan_eggersto_1" class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="stefan_eggersto_2-1685542229153.png" style="width: 999px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/11995i57AA3BF0D68B72B4/image-size/large?v=v2&amp;px=999" role="button" title="stefan_eggersto_2-1685542229153.png" alt="stefan_eggersto_2-1685542229153.png" /></span> <P>&nbsp;</P> <P>&nbsp;</P> </DIV> </DIV> Wed, 31 May 2023 14:11:21 GMT https://community.dynatrace.com/t5/DQL/Single-avg-value-instead-full-timeseries/m-p/213679#M14 stefan_eggersto 2023-05-31T14:11:21Z https://community.dynatrace.com/t5/DQL/Single-avg-value-instead-full-timeseries/m-p/213753#M20 <P>Hi Stefan, the timeseries command produces an array of data points. If you need to aggregate these values, you can use one of the available array functions. In this case, it would be the <A href="https://www.dynatrace.com/support/help/shortlink/dql-functions#arrayAvg" target="_self">arrayAvg function</A>, like so:</P> <P>&nbsp;</P> <LI-CODE lang="markup">timeseries cpu=avg(dt.host.cpu.usage), by:dt.entity.host | fields cpu=arrayAvg(cpu), dt.entity.host</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 01 Jun 2023 11:07:18 GMT https://community.dynatrace.com/t5/DQL/Single-avg-value-instead-full-timeseries/m-p/213753#M20 educampver 2023-06-01T11:07:18Z