Custom Sprint Report with Story Points and Forecast

Hello,

I want to create a custom report in EAZYBI to show

|a)items story pointed and forecasted to a Sprint
|b)|items not story pointed but forecasted to a Sprint
|c)items story pointed and not forecasted to any Sprint?
|d)items not story pointed and not forecasted to a Sprint

Hi @Vinod_Reddy ,
Welcome to the eazyBI Community :wave: !

In eazyBI, there is [Sprint].[(no board)].[(no sprint)] member in the Sprint dimension that identifies which issues don’t have assigned sprint. Also, you can benefit from the measure Issues with Story Points created to see which issues have Story Points.

  • You can use them in a tuple to get Issues with Story Points, but without sprint using this formula. Create a new calculated member in Measure dimension for (|c)items story pointed and not forecasted to any Sprint):
(
  [Measures].[Issues with Story Points created],
  [Sprint].[(no board)].[(no sprint)]
)
  • Then subtract from all issues that don’t have sprint issues that have story points and no sprint. So you will get issues that have no story points and no sprint (|d)items not story pointed and not forecasted to a Sprint)
(
  [Measures].[Issues created],
  [Sprint].[(no board)].[(no sprint)]
)
-
(
  [Measures].[Issues with Story Points created],
  [Sprint].[(no board)].[(no sprint)]
)
  • Substract from all issues with story points issues that don’t have sprint but have story points. And you will get issues with story points and with sprints (|a)items story pointed and forecasted to a Sprint):
[Measures].[Issues with Story Points created]
-
(
  [Measures].[Issues with Story Points created],
  [Sprint].[(no board)].[(no sprint)]
)
  • And last, to get |b)|items not story pointed but forecasted to a Sprint, you first need tocreate measure to show Issues without story points using this formula:
[Measures].[Issues created]-
[Measures].[Issues with Story Points created]

And then use the above newly created measure “Issues without Story points” to create another measure for issues without story points, but with sprint:

NonZero(
  [Measures].[Issues without Story points]-
  ([Measures].[Issues without Story points],
  [Sprint].[(no board)].[(no sprint)])
)

Best,
Gerda // support@eazyBI.com