How to aggregate a custom date inside a specific week?

Questions & Answers
,
1

Hi All,

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

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

Thanks in advance.

2

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:

Aggregate(
  Filter(
    [Time.Weekly].[Day].Members,
    DateBetween(
      [Time.Weekly].CurrentMember.StartDate,
      'Sep 01 2018', 'Sep 09 2018')
))

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

eazyBI%20Time%20weekly%20hierarchy
eazyBI Time weekly hierarchy.jpg1256×744 83.8 KB

For more calculated members examples please see eazyBI demo account: https://eazybi.com/accounts/1000/cubes

Best,
Zane / support@eazyBI.com

3

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.