I am creating a report for "Time in Source Status" for all transition. i have fetched the details using changegroup and changeitem however the issue is that some transitions are recorded with a difference of 1 hour from UI and some records are recorded without time difference which is leading to inconsistency in report.
i can't see any pattern for those transitions which are having no difference with UI hence i can't add\substract 1 hour in order to make the report accurate.
Is there way by which it can be fixed? is there any way by which we can get "Time in Source Transition" somewhere in jira database so that i can pick whatever it is present ?
Thank you in advance
Other plugin options would be the Structure Plugin: https://wiki.almworks.com/display/structure/Time+in+Status+Column or eazyBI reporting: https://wiki.almworks.com/display/structure/Time+in+Status+Column
The most cost effective and easier to use would be Time In status.
Hi @Prakhar Raj
If you would be interested in a ready made solution, you may want to try out our plugin,
It provides 3 major functionalities in one add-on
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events