Grouping Data By Month Based On Created Date

Questions & Answers
, ,
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