Emma Hudson Posted November 29, 2019 Share Posted November 29, 2019 Hi Everybody I am trying to calculate an an average between two dates (01/01/2019 to 31/10/2019) which also takes account of the filter. I know that I need to use AVG and the OVER funtion but I can't get get it to work. Mine either gives me an error or gives me some sort of average that I can't reconcile back to my data. Can anyone help me please I have attached some sample data. I would like the bar chart on the right to contain the average while the chart on the left is a simple sum. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now