Displaying Partial Weekly Time Dimension

Questions & Answers
1

Hi All,

I am new-ish to eazyBI and I am struggling to find a way to weekly Time member with a partial week…

I have created a calculated Time member to encompass the time period I require…

Aggregate([Time.Weekly].[Week].DateMembersBetween('2021/02/24', '2021/05/04'))

Which works fine but selects only the next full week (ie. 24-Feb was a Wednesday, so it selects 1-Mar as the first week to display)
I want to have the granualarity of weeks, but be able to start the period from any day of the week.
So for the week containing 24-Feb, I want it to be a partial week, and sum up the created issues for that week since the 24-Feb (not the monday before)

Is this possible?

2

Hi,

One suggestion is to aggregate the time members at the day level:

Aggregate([Time.Weekly].[Day].DateMembersBetween('2021/02/24', '2021/05/04')

This formula gives the precise period of days. The shortage of this solution is that aggregates with many members could have impacts on the report performance.

The time member could be more elaborated to aggregate the full weeks and the days for partial weeks:

Aggregate(
  {
   [Time.Weekly].[Day].DateMembersBetween('2021/02/24','2021/02/28'),
   [Time.Weekly].[Week].DateMembersBetween('2021/02/24', '2021/04/26'),
   [Time.Weekly].[Day].DateMembersBetween('2021/05/03','2021/05/04')
  }
)

Kindly,
Janis, eazyBI support

3

Thanks @janis.plume,
The second option works very well, thank you!