Need help in generating a report based on status

Questions & Answers
, , ,
1

Hi Team,

We have a situation where we will have “Application code” with one value and have multiple stories with same Application code which are in different statuses.

when we pull out a report it should show something like the attached file.

For example, if we have to number to the statuses, then it will be
Pending - 6
Not Started - 5
In progress - 4
Testing - 3
Cancel - 2
Done -1

Now if we have multiple stories with same Application code , with different statuses, the output should show in the highest valued status only.

Please help me in generating the above report .

Statuses
Statuses594×511 10.9 KB

Thanks, Bhargavi

2

@Elita.Kalane , Could you plz look into this and help me with the required report.

3

Hi @Bhargavi,

You might create the following construction that looks up the current status from the report context and then filters the applications if they have any issues opened for the current status and do not have any issues in higher-valued statuses.

The expression might be as follows.

Nonzero(
CASE
 WHEN
  [Status].CurrentHierarchyMember.Name = "Done"
 THEN
  Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
   AND
   NOT
--sum of higher valued statuses issues
   (
   ([Measures].[Issues created],
    [Status].[Cancel])
   +
   ([Measures].[Issues created],
    [Status].[Testing])
   +
   ([Measures].[Issues created],
    [Status].[In Progress])
   +
   ([Measures].[Issues created],
    [Status].[Pending])
   +
   ([Measures].[Issues created],
    [Status].[Not Started])
   ) >0
  ))
 WHEN
 [Status].CurrentHierarchyMember.Name = "Cancel" 
 THEN
  Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
   AND
   NOT
--sum of higher valued statuses issues
   (
   ([Measures].[Issues created],
    [Status].[Testing])
   +
   ([Measures].[Issues created],
    [Status].[In Progress])
   +
   ([Measures].[Issues created],
    [Status].[Pending])
   +
   ([Measures].[Issues created],
    [Status].[Not Started])
   ) >0
  )) 
 WHEN
  [Status].CurrentHierarchyMember.Name = "Testing"  
 THEN
   Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
   AND
   NOT
--sum of higher valued statuses issues
   (
   ([Measures].[Issues created],
    [Status].[In Progress])
   +
   ([Measures].[Issues created],
    [Status].[Pending])
   +
   ([Measures].[Issues created],
    [Status].[Not Started])
   ) >0
  ))
 WHEN
  [Status].CurrentHierarchyMember.Name = "In Progress"  
 THEN
   Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
   AND
   NOT
--sum of higher valued statuses issues
   (
   ([Measures].[Issues created],
    [Status].[Pending])
   +
   ([Measures].[Issues created],
    [Status].[Not Started])
   ) >0
  ))
 WHEN
  [Status].CurrentHierarchyMember.Name = "Pending"  
 THEN
   Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
   AND
   NOT
--sum of higher valued statuses issues
   (
   ([Measures].[Issues created],
    [Status].[Not Started])
   ) >0
  ))
 WHEN
  [Status].CurrentHierarchyMember.Name = "Not Started"  
 THEN
   Count(
   Filter(
--create set of selected applications
   DescendantsSet(
    [Application code].CurrentHierarchyMember,
    [Application code].[Application code]),
--relevant to current status
   [Measures].[Issues created]>0
  )) 
END)

Depending on your setup and report context - you might have to add a specific Issue Type within the tuples or reset some dimensions.

Regards,
Oskars / support@eazyBI.com