We have data for the past 3 years loaded, and the user can select any particular weeks. I have a line chart with Week as dimension and avg(Amount) as expression and all is fine. Now i need to show 52 week average in the line chart, along with the selected weeks. 52 Week average can be calculated as avg of past 52 weeks data. How can i achieve this?
