How to create a measure to get a created for Issues created in last 6 months and are in specific status (eg. New or Ready))

Questions & Answers
,
1

(
[Measures].[Issues created],
[Time].[Last 6 Months]
)

2

Hi @Aditya2528,

If you wish to see this measure split by various statuses, you can add the Status dimension in the report right next to the measure.

Otherwise, if you only wish to get issues in one particular status, you are on the right track by using tuples. You would only add the Status dimension member to your measure, e.g.:

(
  [Measures].[Issues created],
  [Time].[Last 6 Months],
  [Status].[New]
)

If you would need a group of statuses, you would first make an Aggregate(…) of Status dimension members in the Status dimension in a similar way as you have the Time dimension member :

Aggregate({
  [Status].[New],
  [Status].[Ready]
})

And then add this status group to your Measure (assuming “New and Ready” is the name of your calculated Status dimension member):

(
  [Measures].[Issues created],
  [Time].[Last 6 Months],
  [Status].[New and Ready]
)

Lauma / support@eazybi.com

3

Thanks @lauma.cirule , this helps.

1 Like