Previous Status of JIRA

Questions & Answers
, ,
1

I am trying to accomplish status of JIRA issue in last week. I am using below code to accomplish that. I got the result once but then I am getting
“Failed to execute query. Error message:”
What am I missing here.
case when
([Measures].[Issues history],
[Time].[Day].DateMember(‘7 days ago’)) > 0
THEN
Filter(
–set of project statuses within filtered statuses
Descendants(
[Transition Status].CurrentHierarchyMember, [Transition Status].[Transition Status]),
–condition to find the status that was relevant
([Measures].[Issues history],
[Time].[Day].DateMember(‘7 days ago’),
[Transition Status].CurrentMember)>0).Item(0).Name
END

2

Hi,

in some cases, the MDX formula interpreter cannot understand the Item(0).Name construction.

It is safer to use GetCaption instead of Name.

Filter(
--set of project statuses within filtered statuses
Descendants(
[Transition Status].CurrentHierarchyMember, [Transition Status].[Transition Status]),
-- condition to find the status that was relevant
([Measures].[Issues history],
  [Time].[Day].DateMember('7 days ago'),
  [Transition Status].CurrentMember)>0).
Item(0).GetCaption

Kindly,
Janis, eazyBI support