Skip to main content
M
mcruz1-Visitor
1-Visitor
July 31, 2015
Solved

What is the simplest way to compute for numbers of days between states ?

  • July 31, 2015
  • 1 reply
  • 3773 views

I am looking for a way to compute for number of days between states in a workflow.  What would be the simplest option to take.  Also, it would be best if the resulting table can be downloaded to an excel spreadsheet so I can manipulate the data in various ways.

The object is to determine how long a specific state took to complete.

Hoping to get an answer soon.

PS.  I am not a developer or technical person.  I am more into project management.  But if this requires a specific technical approach I can have my developer look at it and try it out.

      Best answer by tketz

      hi Manolette,

      i think you want a field like "Days in Current State".

      Your Administrator has to define an integer field " Days in Current State" with the computation:

      IsEmpty(DaysCurrentState(), 0)

      With the export items to excel function you can export this field and modify it in excel (im not sure why you want to modify).

      If you need an matrix for every state you need a field for every state with computation like:

      DaysInState("STATE")

      Also you can get the Average Time in a State for a current set of items (Query):

      Query("Issues for Average days in state", Project, avg(DaysInState("STATE")))

      to display this information you need an item and/or create a report/dashboard

      I hope this helps,

      best regards,

      Tobi

      1 reply

      T
      tketz1-VisitorAnswer
      1-Visitor
      August 3, 2015

      hi Manolette,

      i think you want a field like "Days in Current State".

      Your Administrator has to define an integer field " Days in Current State" with the computation:

      IsEmpty(DaysCurrentState(), 0)

      With the export items to excel function you can export this field and modify it in excel (im not sure why you want to modify).

      If you need an matrix for every state you need a field for every state with computation like:

      DaysInState("STATE")

      Also you can get the Average Time in a State for a current set of items (Query):

      Query("Issues for Average days in state", Project, avg(DaysInState("STATE")))

      to display this information you need an item and/or create a report/dashboard

      I hope this helps,

      best regards,

      Tobi

        K
        KaelLizak16-Pearl
        16-Pearl
        August 7, 2015

        Hello Manolette,

        Did Tobias Ketz‌'s answer resolve your issue?  If so, could you click on the Correct Answer link, to let everyone know that his answer solved your problem? 

        If not, could you let us all know why it was not helpful, so we can continue to try to help you?

        Regards,
        Kael

          Terms & ConditionsCookie settingsAccessibility statement