Forum Discussion

PolarBear's avatar
PolarBear
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate Avg. Days in Status by Priority

I've been trying to figure out a way to do this for several days, but can't get it worked out.  Hoping someone one here can help me. I have a status table that gets updated by employees whenever the...
Need Help
  • PolarBear's avatar
    PolarBear
    6 years ago

    I was able to get it solved by appending the tables to get all the dates in one column, then adding calculated columns to find each change and the days between each change.

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi PolarBear 

 

Could you please kindly elaborate on how to get the Days in your expected table? not quite understand the calculation logic.

  • PolarBear's avatar
    PolarBear
    Icon for Helper I rankHelper I
    6 years ago

    v-diye-msft ,

    ID 1082: Was in a prioriy 1, ordered status from 1/15/20. On 1/18/20, it changed to a prioiry 1, ready to ship status (I am calculating full days, 1/15 - 1/18 is 3 days). Then on 1/20, it changed to a priority 3, ready to ship status (1/18 - 1/20 is 2 days). Lastly, on 1/21, it shipped (effectively closing the ID)  (1/20 - 1/21 is 1 day) and  I don't want to count anything once the ID has ended (shipped).

    Thank you