Grouping Data By Month Based On Created Date

Questions & Answers
, ,
1

Hello all!

I’m able to create a single calculated number displaying the metric I want. That metric is the amount of issues closed/resolved within 24 hours of creation over the past month. What I want is a monthly report grouped on the Issue Created measure for the previously mentioned metric. Essentially, all issues created in the [Time].currentHierarchyMember, that have been resolved within 24 hours of creation is what I am looking for. Help?!

Thanks!

Brandon Viertel

2

Hi @bavierte,
It depends on how your formula works, from the description it sounds that you are using measure Issues resolved within your calculation and because of it, your final measure is grouped by that.
One of the ways how you can override it is to create a calculated measure in Measure dimension where issues grouped by Created at date.

NonZero(
Count(
  Filter(
	  Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
    [Issue].CurrentMember.get('Created at'),
    [Time].CurrentHierarchyMember) 
    AND 
    ([Time].CurrentHierarchy.DefaultMember,
    [Measures].[Your measure]) > 0)
		)
	)

Also, you can see the answer from by colleague here that also gives calculation about issues resolved in the time period and grouped by issues created date:

best,
Gerda // support@eazybi.com

1 Like