https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574459#M78326 <P>The Col Maximum() and Col Minimum() support By variables, so you can just add them to your calculation of the range t20 bis t60</P> <PRE><CODE class=" language-jsl">Col Maximum( :t20 und t60, :Fahrzeug, :Power Limit ) - Col Minimum( :t20 und t60, :Fahrzeug, :Power Limit )</CODE></PRE> Tue, 29 Nov 2022 13:00:17 GMT txnelson 2022-11-29T13:00:17Z https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574441#M78323 <P>Hi all,&nbsp;</P><P>&nbsp;</P><P>I am trying to find a way to determine the length of a charge session of an EV.</P><P>In the data you can see different vehicles which are charged from a start SoC to an end SOC.</P><P>Now I am trying to find a way for a fomula, that gives me the length of the charging procedure for the different vehicles / power outputs.</P><P>I started to pre-select the SOC to be between 20 and 60%. With the column max - cloumn min the solustion works fine for ONE occasion (i.e. vehicle / power output) - is there a way to also do it for all of the single combinations car /power output?</P><P>Please find data sheet attached.</P> Sat, 10 Jun 2023 23:57:28 GMT https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574441#M78323 tbps 2023-06-10T23:57:28Z https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574458#M78325 <P>You can use Fahrzeug and Powerlimit as byVar in your formulas</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1669726229362.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47711iD37A65D75400DD5B/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1669726229362.png" alt="jthi_0-1669726229362.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1669726238970.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/47712i6DFA76C7473EF5E3/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1669726238970.png" alt="jthi_1-1669726238970.png" /></span></P> <P>&nbsp;</P> Tue, 29 Nov 2022 12:51:47 GMT https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574458#M78325 jthi 2022-11-29T12:51:47Z https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574459#M78326 <P>The Col Maximum() and Col Minimum() support By variables, so you can just add them to your calculation of the range t20 bis t60</P> <PRE><CODE class=" language-jsl">Col Maximum( :t20 und t60, :Fahrzeug, :Power Limit ) - Col Minimum( :t20 und t60, :Fahrzeug, :Power Limit )</CODE></PRE> Tue, 29 Nov 2022 13:00:17 GMT https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574459#M78326 txnelson 2022-11-29T13:00:17Z https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574486#M78327 <P>This sounds interesting, thanks <a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366">@jthi</a>&nbsp; for the graph. <a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/10812">@tbps</a> - Maybe there is a presentation here.</P> <P>&nbsp;</P> Tue, 29 Nov 2022 13:49:39 GMT https://community.jmp.com/t5/Discussions/Find-a-way-to-determine-the-length-of-an-data-extract/m-p/574486#M78327 Craige_Hales 2022-11-29T13:49:39Z