# Imported Custom Field & Time Calculations

**URL:** <https://community.eazybi.com/t/imported-custom-field-time-calculations/2463>\
**Category:** Questions & Answers\
**Created:** [July 9, 2019, 11:57am UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463 "2019-07-09T11:57:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![auto98](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@auto98](https://community.eazybi.com/u/auto98)\
**Post date:** [July 9, 2019, 11:57am UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463/1 "2019-07-09T11:57:09Z")

</div>

Hi,

I use EazyBI for Change management and I want to show something that I can’t work out.

As we have overlapping changes, I want to show how much time we spend doing changes per day.

So, we have Requested Window Start (RWS) and Requested Window End (RWE).

These are imported as Measure, Value and Property Changes, no option to import as a Dimension.

So effectively I think I need to add the number of minutes between RWS and RWE, then add these daily, to give the graph. But everything I seem to be able to do is using a count of how many issues have RWS/RWE set, rather than seeing the content of the field?

What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [July 29, 2019, 12:17pm UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463/2 "2019-07-29T12:17:16Z")

</div>

Hi @auto98,

From the description, it looks like you would like to see how many issues have an open window (based on begin and end dates) and are overlapping at any day.

 ![image](https://community.eazybi.com/uploads/default/original/2X/9/974be260707f5b0294bfa2b101b14db897518c2b.png)

For this calculated measure, you may use any of the two following approaches.

1. Use function Count() and go through all issues with the begin and the end dates. For each issue validate those dates against the selected period. The formula might look like this:

2. Or build calculated measure similar to “Open issues”. Copy formula of “Open issues” and slightly modify it. Replace Issues create and creation date with measure representing start date. Replace Issues resolved and resolution date with measure representing end date.  
The modified formula might look like this:

More on the calculated measures and used functions are in the documentation: [https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-members)

If this is not your use case, please sketch the report you are trying to build.

Best,  
Zane / support@eazyBI

---

<div class="post-metadata">

**Author:** ![auto98](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@auto98](https://community.eazybi.com/u/auto98)\
**Post date:** [July 29, 2019, 2:14pm UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463/3 "2019-07-29T14:14:46Z")

</div>

Thanks for all that - I’m afraid I must have described it somewhat badly because I _think_ you’re answering something different to what I meant (equally I may be misunderstanding your response!).

Best way I can think of putting it:

In a day there are 24 hours  
In a day there are X number of issues  
Each of those issues has a RWS (date/time custom field) and RWE (ditto) (lets pretend we have 30 of these in a day, and they are all 1 hour each)  
I want to be able to show the actual amount of time we spend doing these issues- ie the total time between RWE and RWS, added together for all issues per day/month

So using the example above, if that were the case every day, I would be able to say “for every 24 hours, we do 30 hours of changes”

edit: Yes I see where I worded it badly - the overlapping bit doesnt have anything to do with it other than the fact they overlap means there can be more than 24 hours worth of issues in every 24 hours, apologies

---

<div class="post-metadata">

**Author:** ![lauma.cirule](https://community.eazybi.com/user_avatar/community.eazybi.com/lauma.cirule/32/8830_2.png) [@lauma.cirule](https://community.eazybi.com/u/lauma.cirule)\
**Post date:** [August 12, 2019, 12:15pm UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463/4 "2019-08-12T12:15:09Z")

</div>

Hi John,

I will jump in your conversation with another suggestion - in the case you have now described you can use the [DateDiffDays(…) function](https://docs.eazybi.com/display/EAZYBI/DateDiffDays) and sum the days from RWS date to RWE date. In the example below the issues would be grouped on Time by the RWS date:

```
Sum( -- Filter issues that have RWS date in the period
  Filter(Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    DateInPeriod([Issue].CurrentHierarchyMember.get('RWS'), 
      [Time].CurrentHierarchyMember) AND -- and when RWE date is not empty
    NOT IsEmpty([Issue].CurrentHierarchyMember.get('RWE')) AND -- and are created in the current report context
    ([Measures].[Issues with RWS], 
     [Time].CurrentHierarchy.DefaultMember) > 0 
  ), 
      DateDiffDays(
        [Issue].CurrentMember.get('RWS'),
        [Issue].CurrentHierarchyMember.get('RWE'))
)

```

Please make sure that the naming of all measures and properties match your Jira/eazyBI setup.  
Lauma / [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![auto98](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/e47774/32.png) [@auto98](https://community.eazybi.com/u/auto98)\
**Post date:** [September 24, 2019, 3:47pm UTC](https://community.eazybi.com/t/imported-custom-field-time-calculations/2463/5 "2019-09-24T15:47:42Z")

</div>

Apologies, for some reason i only just seemed to have got/seen the notification for the reply!

I’ll give that a go tomorrow, looks to be what i need 🙂