Total weeks the projects are running with Ongoing status

Questions & Answers
1

How to add a column with Total number of weeks the projects (epics )are running with Ongoing status.

Regards
Himanshu

2

Hi @himanshushrivastava

You can define a new calculated measure with the following formula:

DateDiffDays(
  [Measures].[Issue status updated date],
  Now()
)/7

This measure will calculate how many weeks have passed since the last time an issue status was updated. Add the “Status” dimension to the Pages section and filter by the “Ongoing” status. This will filter the results and show only those issues currently in the "Ongoing status.

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support