topic Re: how to get a metric that show the duration of a transaction in DQL https://community.dynatrace.com/t5/DQL/how-to-get-a-metric-that-show-the-duration-of-a-transaction/m-p/291031#M2857 <P>Hi&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/86794">@marusla</a>,</P><P>You can simply use OpenPipeline to process your log and add a new field Duration.</P><P>The new field should looks like :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeanBlanc_0-1765207088305.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/31141i5FE8535B5434EB7D/image-size/medium?v=v2&amp;px=400" role="button" title="JeanBlanc_0-1765207088305.png" alt="JeanBlanc_0-1765207088305.png" /></span></P><P>Best regards,</P> Mon, 08 Dec 2025 15:18:41 GMT JeanBlanc 2025-12-08T15:18:41Z how to get a metric that show the duration of a transaction https://community.dynatrace.com/t5/DQL/how-to-get-a-metric-that-show-the-duration-of-a-transaction/m-p/290873#M2841 <P>i have a log, by example , i want to create a maketimeseries that show the fluctuation of Duration fields on time , please could you help me&nbsp;</P><TABLE width="498"><TBODY><TR><TD width="80">Transaction</TD><TD width="182">Start&nbsp;</TD><TD width="156">End</TD><TD width="80">Duration</TD></TR><TR><TD>1aa</TD><TD>2025-12-04 13:00:56.023</TD><TD>2025-12-04 13:00:56.039</TD><TD>16 ms</TD></TR><TR><TD>2aa</TD><TD>2025-12-04 13:00:57.023</TD><TD>2025-12-04 13:00:57.034</TD><TD>11 ms</TD></TR></TBODY></TABLE><P>&nbsp;</P> Thu, 04 Dec 2025 18:23:06 GMT https://community.dynatrace.com/t5/DQL/how-to-get-a-metric-that-show-the-duration-of-a-transaction/m-p/290873#M2841 marusla 2025-12-04T18:23:06Z Re: how to get a metric that show the duration of a transaction https://community.dynatrace.com/t5/DQL/how-to-get-a-metric-that-show-the-duration-of-a-transaction/m-p/291031#M2857 <P>Hi&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/86794">@marusla</a>,</P><P>You can simply use OpenPipeline to process your log and add a new field Duration.</P><P>The new field should looks like :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeanBlanc_0-1765207088305.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/31141i5FE8535B5434EB7D/image-size/medium?v=v2&amp;px=400" role="button" title="JeanBlanc_0-1765207088305.png" alt="JeanBlanc_0-1765207088305.png" /></span></P><P>Best regards,</P> Mon, 08 Dec 2025 15:18:41 GMT https://community.dynatrace.com/t5/DQL/how-to-get-a-metric-that-show-the-duration-of-a-transaction/m-p/291031#M2857 JeanBlanc 2025-12-08T15:18:41Z