Hi all. I have a bar chart with some daily figures on it. What I would like to do is add a second expression in the form of a line chart, where the line shows the 'rolling monthly average' of the actuals shown on the bar.
I have struggled to find the right expression to achieve this, with no success. Attached is an example QVW file where I have explained what I am after in a bit more detail.
If anyone could give me some pointers it would be much appreciated!
Hello. I was reading this post and accidentally 'suggested' an answer. I am not able to to 'un' suggest it, but I believe you are. Please undo my suggestion. I have not testing the approach outlined in Paul's comment.
