Hi QlikTechies...I'm really hoping one of you very clever people out there can help me solve this problem, please!
I need to replicate the table below. The problem column is "Last 4 Wk Ton Avg". This is the average, for the last 4 weeks, for that Day of Week.
I've been trying to achive this with a variety of expressions, like rangeavg and aggr, but without success so far. I know I can create the average quite easily in the script, but I'd like (if possible), to keep the calculation dymanic so the user can make selections and the average will update.
Thanks for the advise, it did work once i had created a single dimension with the Date and Day of Week concatinated and then a sort expression to order correctly by Date.
The next step is making sure the Avg is always populated and always for the last 4 weeks. I understand why the Avg doesn't appear for 7 days (you can see the expression I've used below) and I understand why the Avg isn't actually a 4 weekly average until the 29th day (before the 29th Jan it's a 3 week average, before the 22nd a 2 week average etc)...