Find a way to determine the length of an data extract

[#1]

Hi all, 

I am trying to find a way to determine the length of a charge session of an EV.

In the data you can see different vehicles which are charged from a start SoC to an end SOC.

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.

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?

Please find data sheet attached.

[#2 · Accepted solution]

You can use Fahrzeug and Powerlimit as byVar in your formulas

[#3]

The Col Maximum() and Col Minimum() support By variables, so you can just add them to your calculation of the range t20 bis t60

Col Maximum( :t20 und t60, :Fahrzeug, :Power Limit )
- Col Minimum( :t20 und t60, :Fahrzeug, :Power Limit )

[#4]

This sounds interesting, thanks @jthi  for the graph. @tbps - Maybe there is a presentation here.