https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/810443#M4906 <P>Hi! We are using an HS-premade report for our onboarding KPIs that measure the <STRONG>time to close for each ticket</STRONG>. The report seems to be based on the create date, but I was wondering if there was any way to display the <STRONG>closed date</STRONG> instead?&nbsp;<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2023-06-21 at 3.19.48 PM.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/93451i78FEE82515EB2FAD/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2023-06-21 at 3.19.48 PM.png" alt="Screen Shot 2023-06-21 at 3.19.48 PM.png" /></span></P><P> </P> Wed, 21 Jun 2023 19:38:05 GMT MLatulippe 2023-06-21T19:38:05Z https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/810443#M4906 <P>Hi! We are using an HS-premade report for our onboarding KPIs that measure the <STRONG>time to close for each ticket</STRONG>. The report seems to be based on the create date, but I was wondering if there was any way to display the <STRONG>closed date</STRONG> instead?&nbsp;<BR /><BR /></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2023-06-21 at 3.19.48 PM.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/93451i78FEE82515EB2FAD/image-size/medium?v=v2&amp;px=400" role="button" title="Screen Shot 2023-06-21 at 3.19.48 PM.png" alt="Screen Shot 2023-06-21 at 3.19.48 PM.png" /></span></P><P> </P> Wed, 21 Jun 2023 19:38:05 GMT https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/810443#M4906 MLatulippe 2023-06-21T19:38:05Z https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/810625#M4907 <P>Hi&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/479305">@MLatulippe</a>,<BR /><BR />Thank you for posting in the Community <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />I would like to invite a couple of subject matter experts to this conversation:&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/66301">@Bryantworks</a>,&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/484534">@Franci</a>&nbsp;and&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/6416">@NicoleSengers</a>: have you already made such a report? Do you have any tips on how to achieve this report, please?<BR /><BR />Thanks and have a lovely day!<BR />Bérangère</P> Thu, 22 Jun 2023 08:11:02 GMT https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/810625#M4907 BérangèreL 2023-06-22T08:11:02Z https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/811801#M4916 <P><SPAN>Hello&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/479305">@MLatulippe</a>,</SPAN></P> <P>&nbsp;</P> <P><SPAN>Please follow the screenshot below for the correct setup.</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Franci_3-1687767125968.png" style="width: 400px;"><img src="https://community.hubspot.com/t5/image/serverpage/image-id/93652iD4C99F43CE401744/image-size/medium?v=v2&amp;px=400" role="button" title="Franci_3-1687767125968.png" alt="Franci_3-1687767125968.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN>.1 Create a Custom Ticket Report</SPAN></P> <P>&nbsp;</P> <P><SPAN>.2 Select the Table Chart</SPAN></P> <P>&nbsp;</P> <P><SPAN>.3 Add the following properties:</SPAN></P> <UL> <LI style="font-weight: 400;" aria-level="1"><SPAN>Ticket Name</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Time to close</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Pipeline -&gt; This is useful if you have more than one pipeline</SPAN></LI> </UL> <P>&nbsp;</P> <P><SPAN>.4 Save and publish report</SPAN></P> <P>&nbsp;</P> <P>Please let me know if you have any questions!</P> <P>Thank you&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/230185">@BérangèreL</a>&nbsp;for mentioning me.</P> <DIV class="UserSignature lia-message-signature"><BR /> <TABLE style="font-size: medium; font-family: 'verdana';" width="668px" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="668.255px"> <TABLE style="font-size: medium; font-family: 'verdana';" width="590px" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="140.8px" style="vertical-align: middle; width: 150;"><SPAN class="sc-kgAjT cuzzPp"> <!-- ADD IN SRC YOUR IMAGE URL --> <IMG style="max-width: 130px;" src="https://4686929.fs1.hubspotusercontent-na1.net/hubfs/4686929/immagine%20firma%20community%20-%20non%20cancellare/francesco%20collacciani.jpg" border="0" alt="avatar" width="130" /> <!-- --> </SPAN></TD> <TD width="143.2" style="vertical-align: middle;"> <H3 class="sc-fBuWsC eeihxG" style="margin: 0px; font-size: 18px; color: #000000;"><!-- NAME --><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">Francesco&nbsp;</FONT></FONT></FONT></FONT><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">Collacciani</FONT></FONT></FONT></FONT></H3> <P class="sc-fMiknA bxZCMx" style="margin: 0px; color: #000000; font-size: 14px; line-height: 22px;"><!-- YOUR ROLE --><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">Specialista HubSpot</FONT></FONT></FONT></FONT></P> <P class="sc-dVhcbM fghLuF" style="margin: 0px; font-weight: 500; color: #000000; font-size: 14px; line-height: 22px;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">Exelab</FONT></FONT></FONT></FONT></P> <!-- align center the images in this table , add in style="text-align:center" --> <TABLE style="font-size: medium; font-family: 'verdana'; padding-top: 10px; text-align: center;" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="80"><IMG style="max-width: 60px;" src="https://www.exelab.com/hubfs/raw_assets/public/hs_exelab/images/Diamond-HS%202.png" border="0" alt="lui suo diamante" width="60" /></TD> <TD width="80"><IMG style="max-width: 50px;" src="https://www.exelab.com/hubfs/raw_assets/public/hs_exelab/images/logo-exelab-black-mobile.svg" border="0" alt="exlab-logo" width="50" /></TD> </TR> </TBODY> </TABLE> </TD> <TD width="40.8px"> <DIV style="width: 30px;">&nbsp;</DIV> </TD> <TD width="267.275px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR style="vertical-align: middle;"> <TD width="51.6px" height="28px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD style="vertical-align: bottom;"><SPAN class="sc-jlyJG bbyJzT"><IMG class="sc-iRbamj blSEcj" src="https://3963388.fs1.hubspotusercontent-na1.net/hubfs/3963388/feature%20images/email.png" border="0" width="20" /></SPAN></TD> </TR> </TBODY> </TABLE> </TD> <TD width="204.075px" height="28px" style="padding: 0px;"><A href="mailto:&quot;francesco.collacciani@exelab.com&quot;" target="_blank" rel="noopener"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">francesco.collacciani@exelab.com</FONT></FONT></FONT></FONT></A></TD> </TR> <TR style="vertical-align: middle;"> <TD width="51.6px" height="28px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD style="vertical-align: bottom;"><SPAN class="sc-jlyJG bbyJzT"><IMG class="sc-iRbamj blSEcj" src="https://3963388.fs1.hubspotusercontent-na1.net/hubfs/3963388/feature%20images/web.png" border="0" width="20" /></SPAN></TD> </TR> </TBODY> </TABLE> </TD> <TD width="204.075px" height="28px" style="padding: 0px;"><A href="http://exelab.com" target="_blank" rel="noopener"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;"><FONT style="vertical-align: inherit;">exelab.com</FONT></FONT></FONT></FONT></A></TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> <!-- A table with 2 images in the same row with some space in top --></DIV> Mon, 26 Jun 2023 09:00:25 GMT https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/811801#M4916 Franci 2023-06-26T09:00:25Z https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/813002#M4932 <P>Hello&nbsp;<a href="https://community.hubspot.com/t5/user/viewprofilepage/user-id/479305">@MLatulippe</a>,</P> <P>&nbsp;</P> <P><STRONG>If my answer helped solve your problem, you can <U>accept my reply as a solution</U>. This will help others find the answer.</STRONG></P> <P>&nbsp;</P> <DIV class="UserSignature lia-message-signature"><BR /> <TABLE style="font-size: medium; font-family: 'verdana';" width="668px" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="668.255px"> <TABLE style="font-size: medium; font-family: 'verdana';" width="590px" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="140.8px" style="vertical-align: middle; width: 150;"><SPAN class="sc-kgAjT cuzzPp"> <!-- ADD IN SRC YOUR IMAGE URL --> <IMG style="max-width: 130px;" src="https://4686929.fs1.hubspotusercontent-na1.net/hubfs/4686929/immagine%20firma%20community%20-%20non%20cancellare/francesco%20collacciani.jpg" border="0" alt="avatar" width="130" /> <!-- --> </SPAN></TD> <TD width="143.2" style="vertical-align: middle;"> <H3 class="sc-fBuWsC eeihxG" style="margin: 0px; font-size: 18px; color: #000000;"><!-- NAME --> Francesco<FONT color="#FFFFFF">.</FONT>Collacciani</H3> <P class="sc-fMiknA bxZCMx" style="margin: 0px; color: #000000; font-size: 14px; line-height: 22px;"><!-- YOUR ROLE --> HubSpot Specialist</P> <P class="sc-dVhcbM fghLuF" style="margin: 0px; font-weight: 500; color: #000000; font-size: 14px; line-height: 22px;">Exelab</P> <!-- align center the images in this table , add in style="text-align:center" --> <TABLE style="font-size: medium; font-family: 'verdana'; padding-top: 10px; text-align: center;" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD width="80"><IMG style="max-width: 60px;" src="https://www.exelab.com/hubfs/raw_assets/public/hs_exelab/images/Diamond-HS%202.png" border="0" alt="hs diamond" width="60" /></TD> <TD width="80"><IMG style="max-width: 50px;" src="https://www.exelab.com/hubfs/raw_assets/public/hs_exelab/images/logo-exelab-black-mobile.svg" border="0" alt="exelab logo" width="50" /></TD> </TR> </TBODY> </TABLE> </TD> <TD width="40.8px"> <DIV style="width: 30px;">&nbsp;</DIV> </TD> <TD width="267.275px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR style="vertical-align: middle;"> <TD width="51.6px" height="28px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD style="vertical-align: bottom;"><SPAN class="sc-jlyJG bbyJzT"><IMG class="sc-iRbamj blSEcj" src="https://3963388.fs1.hubspotusercontent-na1.net/hubfs/3963388/feature%20images/email.png" border="0" width="20" /></SPAN></TD> </TR> </TBODY> </TABLE> </TD> <TD width="204.075px" height="28px" style="padding: 0px;"><A href="mailto:&quot;francesco.collacciani@exelab.com&quot;" target="_blank" rel="noopener">francesco.collacciani@exelab.com</A></TD> </TR> <TR style="vertical-align: middle;"> <TD width="51.6px" height="28px" style="vertical-align: middle;"> <TABLE class="sc-gPEVay eQYmiW" style="font-size: medium; font-family: 'verdana';" cellspacing="0" cellpadding="0"> <TBODY> <TR> <TD style="vertical-align: bottom;"><SPAN class="sc-jlyJG bbyJzT"><IMG class="sc-iRbamj blSEcj" src="https://3963388.fs1.hubspotusercontent-na1.net/hubfs/3963388/feature%20images/web.png" border="0" width="20" /></SPAN></TD> </TR> </TBODY> </TABLE> </TD> <TD width="204.075px" height="28px" style="padding: 0px;"><A href="http://exelab.com" target="_blank" rel="noopener"> exelab.com</A></TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> <!-- A table with 2 images in the same row with some space in top --></DIV> Wed, 28 Jun 2023 12:20:14 GMT https://community.hubspot.com/t5/Reporting-Analytics/Average-time-to-close-reports-closed-date/m-p/813002#M4932 Franci 2023-06-28T12:20:14Z