Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to get another graph to show just the last 10 days of data
My Date field is ReportDate. The attached seems to bring through every day in 2014 and not just the last 10 days.
ideally I would like to remove the year part so when we are on the 2nd Jan 2015 it will show 8 days worth of December also.
sum({<Year={$(=Max({1}Year))},ReportDate={">=$(=ReportDate(Max(Reportdate)-10)<=$(=ReportDate(Max(ReportDate))))"}>}RenewedCounter)
Hi Rodney,
Please provide the dummy sample data.
Was there meant to be an attachment?
Hi Rodney
why don't you simply use Dimension Limit ?
Best regards
Chris