Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm creating a dashboard which shows the user statistics for our suite of BI reports. I want to decommission reports which haven't been used this year and show a list of the reports in a straight table like this:-
I have written the following set analysis: =Max({<FinancialYear-={'2014-2015'}>}ReportDate)
This is showing the last time it was run before this year and so heavy duty (recently run) reports are coming up with 31/03/2014 as the last run date when I want to show the last time it was run not including any which may have been run in 2014/15. I hope that makes sense?!
Is what I want to show acheivable with set analysis? Where am I going wrong?
Thanks for any help you can give
Natalie xXx
Maybe like this:
=Max({<ReportName=E({<FinancialYear={'2014-2015'}>}ReportName)>} ReportDate)
If not, then please post a document that demonstrates the problem.
Hi,
try:
=Max({<FinancialYear={'<2014'}>}ReportDate)
Morning
Thank you for your responses but neither of those have worked and I can't attach a document as it's on our server and doesn't have an URL.