Hi Experts,
I would like to build a table showing only issues with details created in the last two weeks.
Instead of creating a custom filter in [issue] dimension, I did in [time], but it doesn’t seem to work. Table shows all the issues instead of only those created within 2 weeks.
The formula I used is below:
Aggregate(
[Time.Weekly].[Week].DateMembersBetween(‘2 weeks ago’, ‘today’)
)
Did I miss anything?
Thanks in advance!
Hi @ADAMKEY ,
You are on the right track. I recommend adding the measure “Issues created” to the report. Then filter the rows with this measure being greater than zero. That will tie the issues in rows with the Time dimension by their creation date. I recommend always using at least one numeric measure in a report. Please see the eazyBI recommendations for creating reports - Best practices for report creation.
Finally, I recommend moving the Time dimension to the report pages for a cleaner look.
See the eazyBI documentation page for more details on filtering report rows - Create reports.
Best,
Roberts // support@eazybi.com
Hi Roberts,
thanks for the advise, it works now!!
Amazing 
BR
Yuan
