Set Analysis to find last set of observation

[Anonymous]

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

[Anil_Babu_Samineni]

PFA

[Anonymous]

actually this show me the first vDays observation not the last? am am after the last, thanks

[Anonymous]

and also  04/01/2017 is treated same as 04/10/2017 so not working at all

[Anil_Babu_Samineni]

First issue resolved

And, second one "and also  04/01/2017 is treated same as 04/10/2017 so not working at all" - How?

[Anonymous]

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

[sunny_talwar · Accepted solution]

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))

[Anonymous]

The bottom on is the one I was after, many thanks

[sunny_talwar]

Awesome