Hi
Data is like,
Week | Amount |
---|
2016-01 | 600 |
2016-02 | 400 |
2016-03 | 100 |
| |
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?
Thanks
KRS