Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I would like to calculate number of days on each WP Status. (Ageing per WP Status)
I have a Progress date when the workflow started and also
a WP ProgressID. Also a Created Date when the incident stated.
I basically need to take the lowest progress ID’s Progress date. Look at when the following one started – Then subtract the time diff.
Do you know how to structure this?
Thank you
Reference No | WP Created Date | WP Progress Date | WP Status | WP ProgressID | =[WP ProgressDate]-[WP CreatedDate] |
- | |||||
1 | 2016-05-16 17:39 | 2016-05-23 10:59 | CLOSED | 6816 | 7.0 |
1 | 2016-05-16 17:39 | 2016-05-23 10:57 | FINALIZE | 6813 | 7.0 |
1 | 2016-05-16 17:39 | 2016-05-17 9:00 | UPDATE | 5770 | 1.0 |
1 | 2016-05-16 17:39 | 2016-05-17 9:00 | VERIFY | 5769 | 1.0 |
1 | 2016-05-16 17:39 | 2016-05-16 17:39 | NEW INCIDENT | 5597 | 0.0 |
May be this:
[WP Progress Date] - FirstSortedValue(TOTAL <[Refrence No]> [WP Progress Date], [WP ProgressID])
With Reference No and WP ProgressID as dimension
Or are you trying to create Created date in the script?
Hi Sunny
Thanks for your speedy reply, but I had internet issues so only getting back to you now.
I'm happy with a backend or frontend expression that will solve this.
The expression you gave gives me the same answer as WP Progress Date - WP Created Date
What I do need is actually days on each WP Status.
This should take the lowest WP Progress Date/ID look at the next WP Progress Date and return the number of days on each WP Status
So by definition WP Progress Date is the Date where the WP Status stated.
Is a backend or frontend script better for this and do you have a solution???
Kind regards