Filter a report by issue start date (start date within 30,60,90 days)

Questions & Answers
1

I am trying to generate a report where I can select rows by Issue Start Date to be used as a look ahead. For example all issues with an issue start date in the next 30,60 and 90 days. I can’t seem to figure out how to get this created as a drop down option versus 3 different reports. Sample report is attached. This should more simple than it has been. Please help!

image
image904×429 22.5 KB

2

Perhaps, the most straightforward solution is to apply the row filter condition where you can adjust the dynamical filtering period:
eafabcbfe120f90dfe6458fb2f9317f9.png

Another solution is to implement calculated members in the Time dimension to aggregate future dates. The formulas for the aggregated members would be like this (for the 90 days period):

Aggregate( [Time].[Day].DateMembersBetween( now(), ‘90 days from now’ ) )

You should also check that you have selected the Start date import as a measure:

73fab806a69fad52a45b058af3e053f5.png

Now you can add the measure to the report, and selection of the new time member would do the filtering:
0033f50d38bac90df01ee2a873a13150.png

You can put a condition on this measure if you wish to remove it from the report for keeping the filter working:

6fd0840c271efe0bf97fee099527f7c3.png

b3ad120bb8d8baa649191c0a00674d33.png

Kindly,
Janis, eazyBI support