How to aggregate a custom date inside a specific week?

Hi All,

Kindly help me generate a calculated member to aggregate specific date into a created week.

September 1 and 2 going to be aggregated inside the week of September 3-9.

Thanks in advance.

Hi @miket,

Weeks are always seven day long time periods; and changing members within a weekly hierarchy is not supported.

However, you may define a new calculated member in Time dimension to group days of a specified period. For example, to get time from Sep 01 2018 till Sep 09 2018, you may use a formula like this:

      'Sep 01 2018', 'Sep 09 2018')

Don’t forget to select weekly hierarchy when creating a calculated member with given formula (see picture below).

For more calculated members examples please see eazyBI demo account:

Zane /

Hi @zane.baranovska,

I want to generate a calculate member where I want to display every 14 days data in the x axis.

For instance:
I have every day data in the db, but I want to club every 14 days data in a month and visualize it in a bar graph (x axis). So it should display Jan 14 and Jan28 data in a month and the rest three days should be carry forward to the next month. So, it should display Jan29-Feb11 data as Feb 11.