Sprint Point Wise categorization

Hi @ajain,

I was also interested by having this report so I gave it a try.

I believe I found a solution (although it might be a bit rudimentary and I’m sure there are also other ways to do it).

What I did is:

On Rows: add issue dimension
On Pages: add sprint
On Columns: add these defined measures:

Measure name: 1SP
CASE WHEN
[Measures].[Issue Story Points] = 1
THEN 1
END

Measure name: 2SP
CASE WHEN
[Measures].[Issue Story Points] = 2
THEN 2
END

Measure name: 13 SP
CASE WHEN
[Measures].[Issue Story Points] = 13
THEN 13
END

This works for us as Story Points for us are only numbers from the Fibonacci modified series.

Select these user defined measures and add total for rows if you prefer.

I then preferred to display it as PIE type.