# Struggeling with an imported insight date field in jira datacube

**URL:** <https://community.eazybi.com/t/struggeling-with-an-imported-insight-date-field-in-jira-datacube/9228>\
**Category:** Questions & Answers\
**Tags:** insight, jira, calculatedmembers\
**Created:** [April 3, 2022, 12:09pm UTC](https://community.eazybi.com/t/struggeling-with-an-imported-insight-date-field-in-jira-datacube/9228 "2022-04-03T12:09:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucas\_Knorr](https://community.eazybi.com/user_avatar/community.eazybi.com/lucas_knorr/32/6704_2.png) [@Lucas\_Knorr](https://community.eazybi.com/u/Lucas_Knorr)\
**Post date:** [April 3, 2022, 12:09pm UTC](https://community.eazybi.com/t/struggeling-with-an-imported-insight-date-field-in-jira-datacube/9228/1 "2022-04-03T12:09:37Z")

</div>

Hello, I have troubles with an imported custom date field.  
I imported an insight custom date field (an expected date) from insight into my jira datacube with the following settings in advanced import settings:

```auto
[jira.customfield_11028]
insight_object_attributes = [
{name = "Expected Date", data_type = "date"},
{name = "Vendor", data_type = "string"},
{name = "Status", data_type = "string"}

```

Furthermore I added a custom member with:

```auto
[Measures].[Enthaltene PO Exptected Date] =
[Enthaltene POs].CurrentHierarchyMember.Get('Expected Date')

```

I want to create a report (bar chart with 3 bars – 1 for every week) which shows which orders we expect within the next 3 weeks. But I can’t figure it out how to aggregate these orders by my imported expected date.

All I got so far is this:

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

Do you have any suggestions? I would love to do this in an insight data cube, but we need to pay attention to some jira status.

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [April 12, 2022, 6:15am UTC](https://community.eazybi.com/t/struggeling-with-an-imported-insight-date-field-in-jira-datacube/9228/2 "2022-04-12T06:15:23Z")

</div>

Hi @Lucas_Knorr,

I recommended you use the Insight data source in a private support conversation. The attribute “Expected date” will be imported as a measure there. In such a case, you can use the Objects in rows and the _Time_ dimension in columns with the respective “Objects with Expected date” measure. The report could look similar to the one below with the “Asset” type objects and their attribute “Purchase date”:

 ![Screenshot 2022-04-12 at 09.06.32](https://community.eazybi.com/uploads/default/original/2X/b/b8ef1afe623d112c29cbee36569dce9e310ce82c.png)

You can use the measure “Issues created” to filter objects referenced in Jira issues.

Suppose you still intend to accomplish this in the Jira data source. In that case, you can define a new calculated measure that checks whether the date from the Insight custom field property is in the current period. For example, the calculated measure formula could look similar to the one below:

```auto
NonZero(IIf(
  DateInPeriod(
    [Measures].[Asset Purchase date],
    [Time].CurrentHierarchyMember
  ),
  1,0
))

```

The report then would look similar to the one in the Insight data source:

 ![Screenshot 2022-04-12 at 09.11.17](https://community.eazybi.com/uploads/default/original/2X/7/713d1c9d88d465ad5e949367dc3f4b3238114b61.png)

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)