Effort in a fixed period Calcualtion

Questions & Answers
,
1

Hi team,

I am trying to gather information on our efforts over a fixed period, by effort I mean Issues that are in the backlog, are in progress or have been completed.

I wrote a calculated measure in the time dimension as follows:

Aggregate(
[time].[month].datemembersbetween(“21 May 2024”, “13 August 2024”)
)

The problem is it is not showing issues between those dates when I select:
Open Issues
Issues Resolved
Issues Closed
in the measures.

I am keen to have a report where I can show people progress of effort through the period outlined above.

Am I not understanding the time bracketing to get the result I am after?

Thanks in advance for any advice you can provide.

Cheers

Dave

2

Hi @David_Horne

The calculated member in the Time dimension that you have searches for the Month level members which start dates fall into your specified time interval and will return only those months with their child members (Days).

In this example, only Jun 1st, Jul 1st and Aug 1st fall between your selection so all days for June, July and August will be returned. And, since there are no issues resolved or closed in these months yet, these measures are returning nothing.

You can rewrite the Time member formula to use day level members instead:

Aggregate(
  [Time].[Day].DateMembersBetween("21 May 2024", "13 August 2024")
)

Let me know if this fits your use case!
​Best regards,
​Nauris

3

@nauris.malitis of course, thanks so much for that. :+1: