Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Calculate between rows
Migrateduser
Hi
I want to calculate some values between rows. I Have this :
* I have group by ID :
*1,2,3,4 is a running count
************************************************************************
ID SUMMARY PrevState New_state Timestamp
120 Campo solo acepta 5 d?gitos
1 Accepted Assigned Sep 14, 2012 10:19 AM
2 Corrected Deployed Sep 14, 2012 2:55 PM
3 Accepted Assigned Sep 17, 2012 10:32 AM
4 Corregid Deployed Sep 17, 2012 4:21 PM
************************************************************************
I Have to calculate the time between the time when it passed from "Accepted" to "Assigned".
How can I do it?
Calculate only when 1-2 , 3-4, etc?. How?.
Also if the last row is Accepted-Assigned show the time between that date and toda.
Hope you can help me!
Find more posts tagged with
Comments
There are no comments yet