Reporting showing actual days in progess and hours logged

I am attempting to build a report to show how many days a story has been in progress and how many hours have been logged.

I built a report but it shows the stories have been “in progress” longer then they actual have been.

It seems the report is counting when the story original went “in progress” even though the story as been moved to “on hold” and then back to “In progress”. I am wanting to know how many days its been back “in progress”.

The issues I am trying to resolve is assoicates are keeping their stories in progress even though they arnt being worked. Id like to see how long the story has been in progress and how many hours have been logged.

For example I have story in progress for 40 days and 1 hour logged. When i drill into it, it really hasn’t been in progress the entire time as it sat in on hold status a majority of the time because we have been waiting on the partner but it was recently moved back to in progress. but my report it count the entire time it was in progress and on hold.

Hi, Anne,

Welcom back to the eazyBI community. This question was asked directly, here is the answer:

Please choose the “Days in transition status” measure together with the “Transition Status” dimension.

If that is not what you are looking for, please send a PrintScreen of the report and report definition for me to see the outline of the report. How to explore the report definition, please find here: Export and import report definitions

Kindly,
Ilze