RTC - Defect Aging report [RRDI]
Hi All,
I created a RRDI Report - with data from ODS->Request State History and ODS->Request. I am looking to the number of days in each state [*for each request]
But i couldn't order the state-change in a sequential manner from the ODS history. ID looks to be in a different order compared to the RTC History.
Please advise.
Thanks. |
2 answers
Hello @valli ,
looking at Request State History the logical thing to sort the states would be to use the "Change Date" field, however this field only contains the date and not the time stamp, meaning that if you have more than one state change in the same day (quite a common scenario) you cannot tell the correct order. One approach could be to check the "Request State ID" and "Previous Request State ID" of each record and rebuild the sequence. This is probably quite complex to accomplish and if there are 2 transitions with the same current and previous state in the same day it's still impossible to tell the right order. Another alternative to investigate would be to sort the records by the "Last Updated" timestamp, this is based on the assumption that the history records are loaded in sequence from the REST API. In my test environment this seems to be the case but I don't have an amount of data big enough to confirm that this is always happening. Best Regards, Francesco Chiossi Comments "Last Updated" timestamp sorting : Will this be applicable for wokflow-based sorting?
I am trying to do a defect aging report at various states and i felt that the states should reflect in proper order as in RTC History itself.
Could you please advise on a defect aging report approach from RRDI? I have used "Request state history" and "Request" in a join-kind of design.
Hi VK L,
I am trying for the same report, number of hrs,min,sec in each state [*for each request].When in critical situations,they might change the state in the same day.
How can i calculate this in Hrs,Mins,Secs rather than in days?
Please advice
|
|
Hi,
I tried ordering by "Last updated", but the "Days in state" value looks to be adding-up and not showing the days-in-state for that particular state. Say, if State A-> State B Transition happens after 8 days of request creation -> "days in state" is 8 here State B -> State C Transition happens on the same day, -> "days in state" is showing 8 here also , shouldnt it be 0? Please advise. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.