https://community.dynatrace.com/t5/DQL/Timeseries-with-entity-name/m-p/213660#M3 <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">When I run the DQL&nbsp;<CODE>timeseries cpu=avg(dt.host.cpu.usage), by:dt.entity.host</CODE>, I only get the ID for each series. When I run the equivalent metric selector&nbsp;<CODE>builtin:host.cpu.usage:splitBy("dt.entity.host")</CODE> in the Data Explorer, the list is broken down by hostname.</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">How can I display the hostname with DQL?</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--dark c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">&nbsp;</DIV> Wed, 31 May 2023 13:44:48 GMT stefan_eggersto 2023-05-31T13:44:48Z https://community.dynatrace.com/t5/DQL/Timeseries-with-entity-name/m-p/213660#M3 <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">When I run the DQL&nbsp;<CODE>timeseries cpu=avg(dt.host.cpu.usage), by:dt.entity.host</CODE>, I only get the ID for each series. When I run the equivalent metric selector&nbsp;<CODE>builtin:host.cpu.usage:splitBy("dt.entity.host")</CODE> in the Data Explorer, the list is broken down by hostname.</DIV> <DIV class="p-rich_text_section">&nbsp;</DIV> <DIV class="p-rich_text_section">How can I display the hostname with DQL?</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="c-message_kit__reaction_bar c-reaction_bar c-reaction_bar--dark c-reaction_bar--collapsed" role="group" data-qa="reaction_bar" aria-label="Reactions" data-stringify-ignore="true">&nbsp;</DIV> Wed, 31 May 2023 13:44:48 GMT https://community.dynatrace.com/t5/DQL/Timeseries-with-entity-name/m-p/213660#M3 stefan_eggersto 2023-05-31T13:44:48Z https://community.dynatrace.com/t5/DQL/Timeseries-with-entity-name/m-p/213749#M19 <P>Hi Stefan, you just add the host.name to the dimensions you want to split by</P> <P>&nbsp;</P> <LI-CODE lang="markup">timeseries cpu=avg(dt.host.cpu.usage), by:{dt.entity.host, host.name}</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 19 Jun 2023 11:11:19 GMT https://community.dynatrace.com/t5/DQL/Timeseries-with-entity-name/m-p/213749#M19 educampver 2023-06-19T11:11:19Z