Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Buenos días, necesito restar datos entre filas, es decir de una misma columna.
Hello, I need to subtract dates between rows, ie the same column.
Name | Time | State | Code |
---|---|---|---|
Person 1 | 01/01/2011 8:16:11 | Logged - in | 0 |
Person 1 | 01/01/2011 16:00:11 | Logout | 130 |
"Time"= 01/01/2011 16:00:11 - 01/01/2011 08:16:11 = 07:44:00
Necesito el restulado en horas de la resta
I need restulado in hours of rest
Soy novato, espero ayuda por favor, muchas gracias por todo
I'm newbie, I hope help please
thank you very much for everything
Hi,
I think you can try chart inter record functions like above, i.e. like this
= interval(Time- above(Time))
as expression in your chart. This will show the time difference between current and above row, for each row in your table.
Hope this helps,
Stefan
ok thanks :-).
ahora se complica un poco mas porque necesito condiciones.
now a little more complicated because I need conditions.
Name | Time | State | Code |
---|---|---|---|
Person 1 | 01/01/2011 8:16:11 | Logged - in | 0 |
Person 1 | 01/01/2011 16:00:11 | Logout | 23658 |
Person 1 01/01/2011 19:00:11 ready 44
Person 1 01/01/2011 19:00:11 Logout 130
Necesito el intervalo de "Time", SI "state"="Logged - in" y "Code"="130".
Need interval of "Time", if "state" = "Logged - in" and "Code" = "130"
Gracias
Thanks for your help
Hi,
to create a time difference, you need to use two rows, so given your above example
- I don't see a matching row for state=Logged in" and Code=130
- If there is a match, to what other row should the interval difference be taken? Using the previous row or the previous row which matches the condition?
Could you provide maybe a more complete data sample (as INLINE table or sample qvw file) and the exprected results?
Regards,
Stefan