Create a Story Point sizing dimension calculated member

I’m trying to create a set of “story size” dimensions to allow reports to be filtered by story size based on Story Points.

We’ve added Story Points as a Dimension but I’m having difficulty creating the “Selected Individual Members” custom calculated member.

I know I can do this by using tuples for example:

(
  [Story Points].[(none)]
)
+
(
  [Story Points].[0.00]
)

But, I want to create 3 groups (small, medium, large) with ranges of ( SP<20, 20<=SP<40, and SP>=40) respectively.

But, I can’t figure out how to build an efficient filter / aggregate and I don’t want to have to try and specify every possible value of Story Points by hand.

Any suggestions?

Thanks in advance,

  • Leeland

@lartra

Please find this community post on how to import “Story points” dimension as interval dimension:

Then you can define intervals for your report to group story point dimension members by custom itervals.

Or you could create calculated members in your current “Story points” dimension using this formula:

Aggregate(
  Filter(
   [Story Points].[Story Points].Members,
   CatchException(CDbl([Story Points].CurrentMember.Name)) < 40
   AND
   CatchException(CDbl([Story Points].CurrentMember.Name)) >= 20
))

This example above would filter story points between 20 and 40

Martins / eazyBI team