Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying display in my mini graphs only the last vDays observation - so for example my vDays variable is 4 so I would like to show only 04/10/2017,03/10/2017,04/01/2017,03/01/2017 ( there are gap between the dates ).
Any idea?
Thank you
Raphael
May be one of these:
Sum({<Date = {"$(='>=' & Date(Max(Date, $(vDays))))"}>}Points)
or
Sum(Aggr(If(Date >= Max(TOTAL <Name> Date, $(vDays)), Points), Name, Date))
PFA
actually this show me the first vDays observation not the last? am am after the last, thanks
and also 04/01/2017 is treated same as 04/10/2017 so not working at all
First issue resolved
And, second one "and also 04/01/2017 is treated same as 04/10/2017 so not working at all" - How?
Not yet...
issue 1) I need the last set of observation (not first) so if vDays is 1 expecting to see only last observation Natalie 80 and Kim 90, not 67, 55
issue 2) it is the same Day value for month 01 and month 10 ?
Thank youy
May be one of these:
Sum({<Date = {"$(='>=' & Date(Max(Date, $(vDays))))"}>}Points)
or
Sum(Aggr(If(Date >= Max(TOTAL <Name> Date, $(vDays)), Points), Name, Date))
The bottom on is the one I was after, many thanks
Awesome