How to create a report with list of all of the issues time between Issue Start Date and Issue End Date?

Questions & Answers
,
1

Hello,

I need to create a dashboard that shows all of the issues that do have start and end date and the count of days from the start date to the end date for each issue.

Appreciate your help

2

Hello,
Welcome to the eazyBI community!

(1) First, check that “Start date” and “End date” custom fields are being imported, and if not, add them to import under the “Custom fields” section.

image.png
image.png1260×962 62.9 KB

(2) Create a report with Issue dimension in rows and include the following measures and properties: [Issue Start date], [Issue End date], [Issues with Start date], [Issues with End date].

image.png
image.png2178×1120 251 KB

(3) Create two filters: [Issues with Start date] > 0 and also [Issues with End date]>0.
After that, you can remove those columns, but the filters will stay.

image.png
image.png1864×808 78.9 KB

(4) Add new report-specific calculated measure with the formula:

DateDiffDays([Measures].[Issue Start date]
,[Measures].[Issue End date])

image.png
image.png1082×594 50.6 KB

Let me know if that works for you or if further guidance is needed.

Kindly,
Ilze

4

Hello,

Thank you so much for help!
When I do that, instead of numbers in Diff between start and end dates I get: mmmm dd yyyy
Do you know how to fix that?

Thank you

5

Hi,
You need to change the formatting of the calculation from Default to Integer or Decimal.

Best,
Ilze

6

Works like a charm, Thank you so much!! :slight_smile: