# Days since issue was flagged

**URL:** <https://community.eazybi.com/t/days-since-issue-was-flagged/7780>\
**Category:** Questions & Answers\
**Tags:** javascript, jira, calculatedmembers\
**Created:** [September 6, 2021, 1:36pm UTC](https://community.eazybi.com/t/days-since-issue-was-flagged/7780 "2021-09-06T13:36:07Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [September 15, 2021, 11:00am UTC](https://community.eazybi.com/t/days-since-issue-was-flagged/7780/5 "2021-09-15T11:00:49Z")

</div>

@joejames

Just thinkging, If you use “Time” dimension in your report to filter the report it would affect the result and filter only changes within the selected time period.  
Try this more universal formula:

```auto
TimestampToDate(
([Measures].[Transition to last timestamp],
[Transition Field].[Flagged],
[Time].Currenthierarchy.DefaultMember
) )

```

And similarly, add **[Time].Currenthierarchy.DefaultMember** in your second formula

Martins / eazyBI

---

_[View the full topic](https://community.eazybi.com/t/days-since-issue-was-flagged/7780)._