How to get weekly avg in textbox ?

[ashmitp869]

Hi there,

1. How to get weekly avg  from the below data in text box ?

2. How to compare it with last month ?

[sergio0592]

Hi,

Take a look here

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245 

[MarcoWedel]

maybe just 7 times the average of SeparationCounts per Ward Episode End Dates, e.g. like this?

Sum(SeparationCount)/Count(Distinct [Wars Episode End Date])*7

hope this helps

Marco