https://community.jmp.com/t5/Discussions/Creating-per-minute-average-values-from-10-every-second/m-p/556295#M77020 <P>If you want to remove seconds and then calculate the average you can create new column with formula such as</P> <PRE><CODE class=" language-jsl">:Time - Second(:Time)</CODE></PRE> <P>to remove seconds from the timestamp. Then aggregate them with Summary table for example:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1665743724509.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46299i24F936F507AB28D9/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1665743724509.png" alt="jthi_1-1665743724509.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1665743749004.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46300i73520D9498F7936D/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1665743749004.png" alt="jthi_2-1665743749004.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_3-1665743759646.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46301iD7607CB2FCA12B28/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_3-1665743759646.png" alt="jthi_3-1665743759646.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 14 Oct 2022 10:37:12 GMT jthi 2022-10-14T10:37:12Z https://community.jmp.com/t5/Discussions/Creating-per-minute-average-values-from-10-every-second/m-p/556276#M77019 <P>Hi,</P><P>I have data appearing 6 times every 10 second and I want to convert that as a per minute data.&nbsp;</P><P>&nbsp;</P><P>Can you please help me with that?&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AlphaPanda86751_0-1665743269802.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46297i95EA2AC3F35F8B70/image-size/medium?v=v2&amp;px=400" role="button" title="AlphaPanda86751_0-1665743269802.png" alt="AlphaPanda86751_0-1665743269802.png" /></span></P><P>&nbsp;</P> Sat, 10 Jun 2023 23:55:17 GMT https://community.jmp.com/t5/Discussions/Creating-per-minute-average-values-from-10-every-second/m-p/556276#M77019 AlphaPanda86751 2023-06-10T23:55:17Z https://community.jmp.com/t5/Discussions/Creating-per-minute-average-values-from-10-every-second/m-p/556295#M77020 <P>If you want to remove seconds and then calculate the average you can create new column with formula such as</P> <PRE><CODE class=" language-jsl">:Time - Second(:Time)</CODE></PRE> <P>to remove seconds from the timestamp. Then aggregate them with Summary table for example:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1665743724509.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46299i24F936F507AB28D9/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1665743724509.png" alt="jthi_1-1665743724509.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1665743749004.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46300i73520D9498F7936D/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1665743749004.png" alt="jthi_2-1665743749004.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_3-1665743759646.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/46301iD7607CB2FCA12B28/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_3-1665743759646.png" alt="jthi_3-1665743759646.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 14 Oct 2022 10:37:12 GMT https://community.jmp.com/t5/Discussions/Creating-per-minute-average-values-from-10-every-second/m-p/556295#M77020 jthi 2022-10-14T10:37:12Z