Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicated data on report

Rodrigo Silva
Contributor
June 1, 2017

Hi,

I've configured a "burn up" report by sprint. The idea is to have an X axis with sprint name and Y with total points (in my case, a custom field) resolved on sprint.
However, for some reason, 2 issues appear under their current sprint (as can be seen on issue detail) and also under "no sprint". I don't know why this is happening. Also as I'm using "Sprint" dimension as Rows, when I select "board" member, these same 2 issues are showed as "no board", while all other issues are on the other configured board.

Here's the calculated field formula I'm using to sum points:

  Sum({PreviousPeriods([Sprint].CurrentHierarchyMember),
      [Sprint].CurrentHierarchyMember},
      [Measures].[Business value resolved]
  )

This field is being used on columns, and, as said, I'm using "Sprint"on rows.

Any ideas on why the data may are duplicated ?

Thanks,

 

1 answer

0 votes
Rodrigo Silva
Contributor
June 2, 2017

Resolved it by removing one of the boards. I've created a new calculated member:

IIF([Sprint].[Board].Members.Item(0) = [Sprint].[Board].CurrentMember, 
0, [Measures].[Business value resolved])

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events