New Meassure by Issue Type

Questions & Answers
, , ,
1

Hi friends!! I have a question about my report.

I have a problem about when my company put the story points because in Epic Type are in “Story Points Bucket” but in “Story, Task , Bug and Spyke” are in “Story Points”.

So that, i want only one column with each one values.

image
image1608×637 47 KB

Im trying with :
image
image

With last formula i have something like i want but in Epic do a Sum of all each members…

image
image1602×734 54.3 KB

Can u help me?

THANKS!!!

2

Hi,

The first formula from your screenshot should be close to what you described. It should refer to the Issue property checking the type of issue in the report rows, not the Issue type dimension:

CASE WHEN
[Measures].[Issue type]="Epic"
THEN
[Measures].[Issue Story Points Bucket]
ELSE
[Measures].[Story points history]
END

Kindly,
Janis, eazyBI support