Create a Story Point sizing dimension calculated member

[martins.vanags]

@lartra

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

How to create a histogram

Hello, I have a simple table (dimension, measure) and I want to create a histogram of values on the measure, to understand data distribution. Any ideas? Thanks

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