Creating Issues with Outlook Date

Questions & Answers
1

Hi, I’m trying to create a measure that is very similar to “Issues with Due Date”. I would like to make an “Issues with Outlook date” so I can plot my outlook over time.

I was trying to use issues open to get me in the right direction to make “Issues Outlook” and here’s where I got.

` CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN

Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
Cache([Measures].[Issues created]
- [Measures].[Issues resolved])
))
+ [Measures].[Issues created]
- [Measures].[Issues resolved]
)
END
– optimized formula for drill through Issue
NonZero(IIF(
DateBeforePeriodEnd(
[Issue].CurrentMember.get(‘Outlook Date’),
[Time].CurrentHierarchyMember),
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]),
0
))`

2

Hi,

Actually, there is a simpler approach to calculate this.

eazyBI recognizes date-picker custom fields by default. Please check if you can already now import your custom field “Outlook Date” as measures via eazyBI import settings.
https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Issues+Import#JiraIssuesImport-JiraCustomFields

This would create in your eazyBI account a new measure “Issues with Outlook Date” which you could use.

Please check and update your eazyBI import settings and import the data to create your expected measure.

Best regards,
Martins / eazyBI team