Formula is not valid error

Questions & Answers
, ,
1

Hi
I am building a Average Age of Working Items (issues) in progress trend report.
I have created the below reports:

Work Items Age in Days
Datediffdays((
[Measures].[Transition to status last date],
[Transition Status].[In Progress],
[Time].CurrentHierarchy.DefaultMember ),
DateAddDays(Now(),1))))

Total Work Item Age In Development
Aggregate( Filter(
[Issue].[Status].Members,
[Issue].CurrentMember.Name = “In Progress” ),
[Measures].[ Work Items Age in Days] ))

Average Age In Development
IIF([Measures].[ Total Work Item Age In Development] = 0, NULL, [Measures].[ Total Work Item Age In Development] / [Measures].[Issues created])

However - the second report comes up with an error
Eazybi 2

Total Work Item Age In Development

I have tried amending [Issue].[Status].Members, to

[Issue].[Status].Level.Members,
[Issue].[Status].Hierarchy.Members,
But then I don’t get any reportable data.

Aggregate(
Filter(
[Issue].[Status].Members,
[Issue].CurrentMember.Name = “In Progress” ),
[Measures].[ Work Items Age in Days] )

Please Suggest

2

Hello @Nagaraju_T
​
​Thanks for sharing your use case and the formulas you are using.

When building eazyBI reports and you need to find out a set of data based on issue properties, you should use the Descendants function which allows to iterate through every issue and the defined/filtered properties. You can learn more and see examples about descendants function here - Descendants
​
​I also suggest you to take a look at our demo account report as it seems like this is something you are looking for. You can use the same report using your own data and adjust it to your requirements,
​Issue days in selected status - Issues - Jira Demo - eazyBI
​
​Additionally - you might find this documentation useful as well to learn more about naming conventions and ​dimensions, hierarchies and levels - Calculated measures and members

Best wishes,

Elita from support@eazybi.com