Filter Function not working w/ calculated time filter

[maxm]

Dear all,

I hope you are doing great!
I am new to EazyBi and probably this problem has an easy solution.

I am trying to create a report which shows the issues due in the next 30 days, 2 Months, 3 Months and Next year. I created it for 30 days (with a date parse in the formula of the screen shot) and it worked fine.

Now I created a custom calculated field in the time dimension to filter for other time dimensions (named above) and replaced the date parse with the page dimension time. The results are correct, but I can not filter for anything else anymore. I created one calculated member per date e.g., one for 30 days, 2 Months etc…

For example I have a second page which clusters all issues in categories, if I select one category it will still show all issues.

I hope you can help me with this!
Thank you very much and best regards,
Max

Screen shot: Calculated measure:

[maxm]

Here is also the image for the date filter:

[gerda.grantina]

Hi @maxm,
welcome to eazyBI community!

You can use measure Issues due together with calculated Time dimension members.

Issues due are all issues that are due (or unresolved) and do not have resolution and resolution date. On the Time dimension they are grouped by issue due dates (if issue does not have a due date then it will be counted only in All Times member).

To create a calculated members in Time dimension, you can use function DateMembersBetween().
As example:

Aggregate(
  [Time].[Day].DateMembersBetween('30 days ago', 'today')
)

In the report it would look like this:

best,
Gerda // support@eazyBI.com