Hi, I am trying to get a count for items with the following characteristics
- Completed within a specific period of time e.g. last 90 days, last 6 months, last 12 months
- The items have time spent against them
I have created the following items:
- Time dimension calculated member using
[Time].[Day].DateMembersBetween(‘90 Days ago’, ‘today’)
- Report specific calculated member formula
[Measures].[Issues with hours spent]
The problem is that the calculated member formula does not include in the results items closed in the time period, with time entries outside the time period. e.g if the total completed items in the period is 34, and the items with time entries is 31, the report show 27 for the items with time.
Looking at the 4 missing items, they are issues with time entries that have dates outside the time period. What do I need to change to include those missing items?