Average of a complex Variable

[leocattqv]

Hi Community,

I am creating a Laney P Chart and am at the final stages.

This is a pretty complex calculation that puts variables upon variables.  The last stage is to average the Z-Score over 12 months

I have attached an App.  the Variable I am trying to get to is vMRBar (Aggr(avg(($(vZi)-Above($(vZi))))))

I Havent worked with Aggr alot, Im not sure its the way to get what I need.

Any suggestions would be appreciated.

thanks

-L

[leocattqv]

I just mean that as I slice the data - the average should change with the slices,

[sunny_talwar]

So, this did work, right?

Avg(TOTAL Aggr($(vMR),MonthYear))

[Shras1609]

I'm trying to do Laney P Chart chart in the Qlik Sense. Can you share the .qvd file with Laney P Chart for Qlik sense? Thanks!