# Aggregate fixVersion status across multiple Jira projects

**URL:** <https://community.eazybi.com/t/aggregate-fixversion-status-across-multiple-jira-projects/5077>\
**Category:** Questions & Answers\
**Tags:** fix-version\
**Created:** [August 19, 2020, 7:46pm UTC](https://community.eazybi.com/t/aggregate-fixversion-status-across-multiple-jira-projects/5077 "2020-08-19T19:46:37Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [August 28, 2020, 10:35am UTC](https://community.eazybi.com/t/aggregate-fixversion-status-across-multiple-jira-projects/5077/2 "2020-08-28T10:35:46Z")

</div>

Hi @pdaly

As you can see in your screenshot, the same fix version can have a different start date and release date in different projects.  
Therefore, there should be a question of what is the correct result on the version level in such report (which project to pick from).  
Assuming you would like to cover all the issues from all projects on the Fix version level (in your report) you could try the following code (earliest version start date)

```
CASE WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND
[Fix Version].CurrentHierarchyMember.Level.name = "Name"
THEN
TimestampToDate(
Min(
Filter(
Childrenset([Fix Version.By name].CurrentHierarchyMember),
[Measures].[Issues created]>0
),
DateToTimestamp([Measures].[Version start date])
))
WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND [Fix Version].CurrentHierarchyMember.Level.name = "Project"
THEN
DateParse([Measures].[Version start date])
END

```

It would return the earliest version start date. You can use this new calculated measure instead of “Version start date” in your report.

And then similarly you could use Max function in that formula to return the last date from Version release date

Martins / eazyBI support

 ![image](https://community.eazybi.com/uploads/default/original/2X/e/e08bb86b928ea8da07bf44faa29a7b472050e4c2.png)

---

_[View the full topic](https://community.eazybi.com/t/aggregate-fixversion-status-across-multiple-jira-projects/5077)._