# Story and Epic report and filters for updated date

**URL:** <https://community.eazybi.com/t/story-and-epic-report-and-filters-for-updated-date/1047>\
**Category:** Questions & Answers\
**Created:** [September 23, 2018, 11:34pm UTC](https://community.eazybi.com/t/story-and-epic-report-and-filters-for-updated-date/1047 "2018-09-23T23:34:42Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [October 3, 2018, 7:23am UTC](https://community.eazybi.com/t/story-and-epic-report-and-filters-for-updated-date/1047/3 "2018-10-03T07:23:56Z")

</div>

Hi,

To see Story’s updated date, you could try selecting the default eazyBI measure “Issue updated date” from “Measures” dimension (from “Issue properties” bucket)

To calculate story’s epic udpated date, you could create a new calculated member in “Measures” dimension using the following code

```
CASE WHEN
[Issue].CurrenthierarchyMember.Hierarchy.Name = "Issue.Epic"
THEN
[Issue].CurrentHierarchymember.Parent.get('Updated at')
ELSE
[Issue.Epic].[Parent].GetMemberbyKey(
    [Issue].CurrenthierarchyMember.Key
).Parent.get('Updated at')
END

```

To calculate Story’s status category try creating a new calculated member in “Measures” dimension using this code

```
[Status.Category].[Status].GetMemberbyKey(
    [Issue].CurrentHierarchyMember.get('Status ID')
).Parent.Name

```

Finally, to calculate Story’s epic status category use this code:

```
CASE WHEN
[Issue].CurrenthierarchyMember.Hierarchy.Name = "Issue.Epic"
THEN
[Status.Category].[Status].GetMemberbyKey(
    [Issue].CurrentHierarchyMember.Parent.get('Status ID')
).Parent.Name
ELSE
[Status.Category].[Status].GetMemberbyKey(
    [Issue.Epic].[Parent].GetMemberbyKey(
      [Issue].CurrenthierarchyMember.Key
    ).Parent.get('Status ID')
).Parent.Name
END

```

Martins / eazyBI support

 ![report%20example](https://community.eazybi.com/uploads/default/original/1X/9780e6b715097186c33d4d6a681313cf4fb4070c.jpeg)

---

_[View the full topic](https://community.eazybi.com/t/story-and-epic-report-and-filters-for-updated-date/1047)._