last date only moving averaged display

[Anonymous]

I am looking for a 3 days moving average - I can calculate it,  using

rangeavg(above(sum(Score),0,3))

but I want to display only the result for the highest date.

so instead of

I would like to see only the yellow highlighted one, when I try to filter my calculation changed since it is ignoring the non filtered. .

I tried to apply so set analysis to it but did not help.

Any idea?

[sunny_talwar]

Try this

rangeavg(above(sum({<MyDate>}Score),0,3)) * Avg(Aggr(If(Max(TOTAL <Name> MyDate) = MyDate, 1), Name, MyDate))

I have assumed that max mydate might differ for each name... if this isn't true, then you can have a simpler expression

[trdandamudi]

Please see the attached file.. (I am using version 12). Hope this is what you are looking for:

[Anonymous]

Not matching original calculations?

moving average is

24/10/2017 Ben       75.33  and not like you have 100

24/10/2017 Julia      75.33 and not like you have 85

[Anonymous]

Not matching original calculations?

moving average is

24/10/2017 Ben       75.33  and not like you have 100

24/10/2017 Julia      75.33 and not like you have 85

[trdandamudi]

Sunny do have the calculations that you need (75.33). Did you check ?

[Anonymous]

no Sunny go something else? no? or am I very confused?

[trdandamudi]

This is what Sunny is getting:

[sunny_talwar]

Are you not seeing this?

[Anonymous]

when I open Sunny's Q (2).qvw

I get:

maybe because I am using Q11 and Sunny is using Q12,any idea?